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.
 
Top