Data Validation in a Table using criteria from another Table

[lindz5970]

Hi, I'm trying to set up Data Validation using data from another table.
I have 2 tables. Table1 contains 2 fields: Member Name and Coverage Date. My second table is just a list of Coverage Dates. My user is going to Edit Table1 by manually entering in a Coverage Date (I have a query set up with a prompt for a window to pop up and they manually type it) but I want the Coverage Date they enter to be ONLY a value from Table2. Is there a way to tell Table1 to only allow me to use a value found in Table2? Any help is greatly appreciated.

Thanks!

[comop1]

Sounds like you want to make a field in table 1 a lookup from table 2. Does that make sense?

[lindz5970]

Sounds like you want to make a field in table 1 a lookup from table 2. Does that make sense?

Sort of, but the Coverage Date the user is entering in Table1 is specific to the Name it's assigned with. So there's nothing in Table 2 that is unique that says which coverage date to use without the user manually selecting it. The user is manually typing the Coverage Date into Table1 so I basically want to get rid of user error by using Table2 as validation.

[pbaldy]

I don't think you can use validation across tables. How about a combo box that gets its selections from table 2, with the limit to list property set to Yes?

[lindz5970]

I don't think you can use validation across tables. How about a combo box that gets its selections from table 2, with the limit to list property set to Yes?

How would I do that? I have the combobox with the dates from Table2, but then do I need to make a query with the combobox to use in the Lookup of Table1?

[pbaldy]

I would expect that your form is bound to table 1, and the combo to the date field in table 1. Its row source would be from table 2.