If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
[ID]
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. |
#2
|
|||
|
|||
[ID]
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. "Kevbro7189" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|