Referencing a Date from a different table in a form

[emassey0411]

Question - can you reference a date from a table into a form that was created from a different table. I am using

 =[cmbBox].[column](x)

for all the text columns that I am bringing into the form but I need to bring in a date. I have the field as a Short Text with a Short Date input mask but it isn't bring the information into the form.

Also, can you do the same thing with a Yes/No field? If so, how??



Thanks for the help

[Gicu]

You can reference\display any column in the row source of a combo as long as you include it in the row source and you set the Columns (number of) property to match the row source field count.

Cheers,

[Micron]

Maybe research DLookup, as long as there is a relationship that "ties" records together between two tables - since I'm not gleaning from your post that you want this to be in the combo list. So that could work if it fits the need and if one half of that relationship was "x" as long as the other half was in the other table.