updating a form

  • Thread starter Thread starter HJC
  • Start date Start date
H

HJC

Hi - would appreciate any help with this problem.

I have a form based on a table which contains a link to a
look up field in another table as well as a look up field
within the table itself. If I add another items to either
list of look ups, how can I get the form to update to
include the new items that I added without deleting the
old field and replacing it with the new field?

Thanks
 
Hi - would appreciate any help with this problem.

I have a form based on a table which contains a link to a
look up field in another table as well as a look up field
within the table itself. If I add another items to either
list of look ups, how can I get the form to update to
include the new items that I added without deleting the
old field and replacing it with the new field?

Thanks
Click to expand...

Two suggestions:

- Requery the Form (either in code or by pressing F9)
- Avoid the use of Lookup fields at all times. Put combo boxes on your
form, by all means - but the table lookup feature IME does more harm
than good.
 
Back
Top