Should be SO easy - How to store form information in a table field

[Christine]

My main form calls a subform from which a user can select
a person's name.

After closing the subform, the main form sucessfuly
displays a text box with the control source set to
=[txtForename] & " " & [txtSurname]

This is fine for verifying that I have actually captured
the values from the subform, but what I *really* want to
do is to store [txtForename] & " " & [txtSurname] in the
table under a field name called Requestor.

I KNOW this is basic stuff, but I can't figure out how to
do it!! Help!

 

[Christine]

Thanks for that, but it seems awfuly complicated since
I've already obtained the information I want. In FoxPro I
could simply enter something like...
Requestor = [txtForename] & " " & [txtSurname]

Christine

 

[John Vinson]

My main form calls a subform from which a user can select
a person's name.

After closing the subform, the main form sucessfuly
displays a text box with the control source set to
=[txtForename] & " " & [txtSurname]

This is fine for verifying that I have actually captured
the values from the subform, but what I *really* want to
do is to store [txtForename] & " " & [txtSurname] in the
table under a field name called Requestor.

Ummm... this is probably a) not necessary and b) a Bad Idea. Storing
the forename and surname redundantly in this table ignores the fact
that you might have two people who happen to have the same name, and
the fact that a person might change their name (and then you'ld have
Mary Jones in the employee database and an otherwise-unknown Mary
Robertson in the Requestor field).

Why not simply have a RequestorID field in this table, and use a Combo
Box displaying the forename & surname but storing the PersonID? No
need for a popup form (note: it's NOT a "subform") at all!

 

[PC Datasheet]

Look at the ther responder's post that confirms the solution I gave you!

BTW, John is the "Wyzard Of Information" - a well deserved title!!!!