Populating Text box from multiple sources

[Guest]

I have a form, which sources from two different tables via a query. I need to
have a text box display information from certain fields from each table. The
control source only gives me one table to choose from. I can't get on with
the expression builder, having tried the Dlookup function - it returns the
info, but not relative to the form (other text boxes on it).

I have managed to get a list combo box to display the info by picking up an
already queried 'AS' field which includes the various fields I require, but I
really would rather not have it in this format as it allows the user to
scroll or drop down other choices - I would much prefer the text box format.
Can anyone help please?

I am a newbie, so be gentle!

Thanks

Martin

 

[Guest]

Ok - I sorted it from reading through another link, whilst not answering it
exactly, did give me a clue - I merely added some SQL to the Form, so as to
pick up the query off another table and added extra Text boxes to display
this info (in design mode, I'd used all the spaces for anymore queries and
thought that was the limit) - if anyone can tell me a better way please do -
learning lots on here!

 

[Jeff L]

If all you are trying to do is paste together some fields then all you
need to do is put
=[Field1] & " " & [Field2] & " " & [Field3] in the control source of
your textbox on your form.

Hope that helps!

 

[Guest]

Yes, thanks Jeff, had sorted that from playing around with it. The prob was I
didn't have the query assigned to the form where I needed the info from -
thanks for your advice.

If all you are trying to do is paste together some fields then all you
need to do is put
=[Field1] & " " & [Field2] & " " & [Field3] in the control source of
your textbox on your form.

Hope that helps!

Ok - I sorted it from reading through another link, whilst not answering it
exactly, did give me a clue - I merely added some SQL to the Form, so as to
pick up the query off another table and added extra Text boxes to display
this info (in design mode, I'd used all the spaces for anymore queries and
thought that was the limit) - if anyone can tell me a better way please do -
learning lots on here!

 

[Guest]

....I should have added that I couldn't get one text box to source two
different tables, hence the need to do two textboxes - it makes little
difference here but if there is a way I guess it would be useful at a later
date?

Yes, thanks Jeff, had sorted that from playing around with it. The prob was I
didn't have the query assigned to the form where I needed the info from -
thanks for your advice.

If all you are trying to do is paste together some fields then all you
need to do is put
=[Field1] & " " & [Field2] & " " & [Field3] in the control source of
your textbox on your form.

Hope that helps!

Ok - I sorted it from reading through another link, whilst not answering it
exactly, did give me a clue - I merely added some SQL to the Form, so as to
pick up the query off another table and added extra Text boxes to display
this info (in design mode, I'd used all the spaces for anymore queries and
thought that was the limit) - if anyone can tell me a better way please do -
learning lots on here!

:

I have a form, which sources from two different tables via a query. I need to
have a text box display information from certain fields from each table. The
control source only gives me one table to choose from. I can't get on with
the expression builder, having tried the Dlookup function - it returns the
info, but not relative to the form (other text boxes on it).

I have managed to get a list combo box to display the info by picking up an
already queried 'AS' field which includes the various fields I require, but I
really would rather not have it in this format as it allows the user to
scroll or drop down other choices - I would much prefer the text box format.
Can anyone help please?

I am a newbie, so be gentle!

Thanks

Martin