Lookup field not working in form

Toeying

Registered User.
Local time
Today, 09:26
Joined
Jul 30, 2010
Messages
79
Hello,
I have created a look up field in one of my tables. The look up data shows in the table view. but when i created a form with the field the look up data did not show up. what am i doing wrong here please?
Thanks
TY
 
thanks for your reply. What is the alternative then. because I want to reduce typing for people using the system by providing a list they can pick from. this list is going to stay constant for most of the time but It will also be great to be able to add new entries when neccessary. what do you advice. Thanks a mill.
Cheers
Ty
 
Setting LookUps in the tables is supposed to generate combos on form but it can go wrong. However it isn't so hard to set up a combo directly from the properties.

RowSourceType sets the source to either a table of query.
RowSource is a query the set the choice of values to be stored and displayed.
ColumnCount sets how many columns from the query are shown.
ColumnWidths controls which ones are displayed.
BoundColumn set which column is the actual data value.

The Ten Comandments and Evils of LookUps in Tables are overstated. They are a useful tool in development. Just don't leave them in place. Remove the lookups from the tables when you have done your forms.
 

Users who are viewing this thread

Back
Top Bottom