Adding a lookup to a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I initially created a form using the wizard from a table called training
courses , which did not have a look up option for one field. Although I can
create a look up option for that field when looking at the table data I cant
get the form to show the look up option.

I can create the lookup by using the wizard again and making a copy of the
training courses, but the form has been customized and there is a
considerable amount of work required.

Please are there any suggestions how to fix this without having to go
through para 2 above
 
I take it you have a text box on your form, and you want it to be a combo
box that shows the value from a lookup table?

If so:
1. Open your form in design view.

2. Right-click the text box, and choose Change To | Combo.

3. Set the properties of the combo:
RowSource NameOfYourLookupTableHere
Column Count 2
Column Widths 0
That assumes your lookup table has an autonumber as the first first, and you
want that hidden and the 2nd field shown instead.
 
Thanks Allen

Sorted the problem and saved a huge amount work, have a great day from a
soon to be covered in Snow Canada

William
 
Back
Top