Access help part II

Mark M · 19 Oct 2007 at 15:24

Is there any way to have a form in access with a drop down box that when selected changes the inputs on the form.

Doesnt sound very clear so I will try and give an example;

Drop down box with "cheque payment" and "credit card payment" to select.

When selected the inputs for each will be slightly different

If cheque selected then the form will be as follows;

ID
Name
Cheque number
Amount
Policy number

If credit card selected then;

ID
Name
Credit card number
Amount
Policy number

Its only the one column that needs changing but it needs to be in a seperate column in the main table and I dont want to have both as I know some people will input into the wrong field.

Thanks for the help, Mark

Munkeh · 19 Oct 2007 at 15:40

Can you do something like this:-

If combobox1.value = "cheque payment" then
label1.caption = "Cheque number"
Else
label1.caption ="Credit card number"
End if

where label1 is the label before the textbox where they enter the cheque number/credit card number?

Mark M · 19 Oct 2007 at 15:52

That sounds almost there but I need the credit card number and cheque number in 2 seperate colums in the main table for reporting purposes.

Munkeh · 19 Oct 2007 at 16:06

well it depends how you are sending the data to the columns but just add label1.caption instead of naming the column if that makes sense. So the data will goto the colum with the caption of label1.

Does that make sense?

Mark M · 19 Oct 2007 at 16:57

Not really but I will have a play and see what I can work out. Im only a noob when it comes to access.

Thanks for the help but keep an eye out as I may be back for more

Munkeh · 19 Oct 2007 at 18:53

post up the code for the form and i'll take a look if you want. Im guessing your coding it in VBA...