I need to return the yes/no value in a table

G

GaryC

TableA contains a field type "yes/no" , moving to tableB I have a form
"Form1" which has a field PartNumber from TableA, I need to query TableA via
PartNumber and then test the field type "yes/no" whether null or (yes/no)

I was trying IIf IsNull and Dlookup Functions stringing them together soon
got too complex for me!

Any Help would be greatly appreciated

Thanks
 
P

Pat Hartman\(MVP\)

Create a query that joins the two tables and use that as the RecordSource
for your form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Three different fields in one record referencing to three different records in another table 1
Refresh form contol when record has changed in a table 1
Form with Subform and a Yes/No field 1
Display Yes/No instead of -1, 0 on Search Forms 1
Check Box - Need "Yes" value to return 1 to linked table 1
Yes/No in a List Box 1
Case When Then , or If Then for Form Field 1
Issue with absolute walues in a yes/no table 6

Top