Looking up a check box

[Bastien]

Hi<br><br>I have a db with 6 distinct forms but all reocrd are one-to-one. What I am trying to do is to look a check box in a table from another form where the ClientID numbers are the same.<br><br>I have tried the Dlookup function but cannot get it right. I have also tried to build a query but when I cut the SQL statement and paste into the code I keep getting a Syntax error or Jet tells me it can't find the table. I just need the value of the check box to see it is true or false for the one CLientID only.<br><br>Also I have one form where I have a combo box with values from a table.&nbsp;&nbsp;How can I get the form to pick the information associated with the info from the combo box and put in on the current form?<br><br>Thanks<br>Bastien

 

[Guest_imported]

Try using a Query and set the CheckBox Creiteria True/Yes<br>or No/False Depending on what you want to do <br><br>example<br>you have 6 distinct Tables create a Query and in each one link them together and then set <br>Checkbox1-Form1-Yes/True<br>Checkbox2-Form2-No/False<br>Checkbox3-Form3-Yes/true(my point is... Is when you run the Query if the Yes/True is not Present it will skip That Info<br>or Vice Versa)<br><br>If you could be a bit more clear on what you want to do i could help<br>