Search results
-
Help on using Foreign Keys to look up foreign data on a Form
ridders.... I'll try re-entering the single and double quotes - as for the "[]"s, every time I enter the Control Source statements without them, Access 2010 puts them back in! It's so frustrating! As I said, I'm partially sighted so clutter like the square brackets is certainly unhelpful (but... -
Help on using Foreign Keys to look up foreign data on a Form
Colin.... You were correct when pointing out that a text box probably contains text (doh!!!), but sadly adding the extra quotes didn't have any discernable effect. I still get the "#Name?" error. The relevant control source statements are For the LocUid textbox... -
Help on using Foreign Keys to look up foreign data on a Form
I am trying to show a value on a form, but can’t work out how to do it. I have been using Excel (cell formulae and VBA) for years, but this is my first venture into Access. I’m not looking for a VBA solution, just trying to work out how to do what I’m sure should be a simple routine task. I...