Search results

OK, I've sorted it now that you've put this explanation on here - thank you for that is was very helpful. Action: extended the form area, selected the TAB control and moved it clear leaving the affected controls where they were. Selected all the disengaged controls, cut them, selected the...

I have a Tab Control on a form but when I add a new page some of the field boxes from the original page appear on the new one, if I delete them off the new one it also deletes them off the original page! I'm running MS XP Pro with MS Access 2003 (SP3) Any ideas? Kent :confused:

Dev - got it! This now returns the correct information: =DLookUp("[Address2]","[Qry_Address4Form]","[ContactID] = Forms![Frm_Contacts]![ContactID]") Thanks Kent

Dev, It would only let me put it in as below: =DLookUp("[AddressLine]","Qry_Address4Form","[ContactID] =" & [ContactID]) but gives me a #Error Any ideas? Kent

I have a form that gives details of my clients and on that ia a tabbed form with various fields - I am trying to get information (concatenadted address line) from a query into it but don't know the syntax - can anyone give my the syntax to get info. into a form field from an unrelated table? :( Kent