Auto Fill fields with drop down list

[stu_c]

Hi all
I have a Table named TBLBookings

on one of the fields I have a Lookup wizard thats linked to a Table named TBLVehicles which includes
Car Reg
Car Type
Location

When I run the TBLBooking and click the drop down list it shows up
Car Reg
Car Type
Location

but once the field is clicked all it shows in the records is the REG where in a form id like to see what vehicle it is location etc

is it possible to have extra fields in the form named Car Type and Location and once the registration is chosen it automatically fills in the correct details for them?

if someone could create me a basic database to show this would be great been on it for ages

 

[John Big Booty]

You can use the following to populate an unbound Text Box, based on the current selection in your Combo Box;

=ComboName.Column([B][COLOR="Red"]x[/COLOR][/B])

Where x is the column number that contains the data you wish to display. Remembering that the columns in a combo, or list box for that matter, are numbered from zero on up.

 

[stu_c]

You can use the following to populate an unbound Text Box, based on the current selection in your Combo Box;

=ComboName.Column([B][COLOR=red]x[/COLOR][/B])

Where x is the column number that contains the data you wish to display. Remembering that the columns in a combo, or list box for that matter, are numbered from zero on up.

little confused :\

 

[pr2-eugin]

Are you having lookups at table level..???

If your answer to that is yes.. Stop what you are doing and "Remove Lookup's" by using the method described by Bob.. Access MVP's describes why it is NOT Recommended to do so..

After which you have to think of moving those lookups on to forms.. Take one step at a time.. Remove the lookups and then concentrate on building the interface (i.e. the Form) to show what you want to see..

 

[stu_c]

ok...... think ill pass on this then really confused now