Recent content by rslewis

The text box is on a form which has other controls linked to a table. I have a query which lists several records when run from another table. I want to chose one of those records and insert the field value into the textbox. Rob

Hi Have a query which looks up an address using the text input into a textbox by the user. What i'm now struggling with is getting the query result into the textbox. Am still new to access and am hoping this is something fairly simple. Thanks Rob

Thanks Catalin The address table already has the individual elements of the address and also a field with the concatenated address so a good start I guess. I can run a query on this address line using: Like "*" & [what address?] & "*" Which does give me the list of matched addresses I...

Hi All Have been searching for a way to allow an address to be looked up from a pre-defined table. What I am looking for is that the user can type just part of the address into say, a text box, and are presented with all options which match so that they can chose the correct one. Once chosen...

Hi Everyone Name's Rob, live in Sussex (UK) Am fairly familiar with access but more as a user and now strting to get into fiddling and designing small databases to help me out with various stuff. Cheers Rob