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

G

Guest

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
Select Portion of a Text String 4
Copy a row from Table A to position 0 in Table B 1
Append query - current record only (follow on from Ken Stafford su 2
Make A Query Updateable 1
any ideas for boolean yes/no field in table 4
How to check if a filed is in another table? 1

Top