> [ID]

[Kevbro7189]

I have 2 tables LOG and ADDRESS. In LOG I have a lookup field (ADD LU)
related to ADDRESS. The lookup contains the ID for address. How do I get
ADD LU to automatically populate with the >ID value available?
I have used the Default property in the table to select a specific ID value
before but I can’t seem to get the equation right for the >ID.

 

[Ian]

Better to use a combobox in the form rather than a lookup field. If you
haven't done it before just insert a combobox into the form and the wizard
will walk you thru choosing the source field and where to place the data.

As to the question

Create a query based on Address with a where clause in the ADDID that
includes the specific ID you want it greater than. Assuming there is a
textbox in your form that has the cut-off ID value (i'll call it TextID) and
the form is called frm_LOG then the where clause in the query will be

=[forms].[frm_LOG].[TextID]

Base your combobox on the query you just created (to populate the combobox).

Hope that helps.