Inexperienced Access user

[Guest]

How do I have a combo box return the value of the ID and the name? Also, how
do I get the date field to update a specified field when the form is accessed.

 

[Guest]

You were very brief with your question, so if I don't answer it
satisfactorily, just let me know. It looks like you want a Combo Box with
two fields in it correct? The wizard should help you with this? If not you
can do one of two things:

Create a Query based on the Table with the appropriate information.
Drag down the two fields that you want to appear in the Combo Box.
Save the Query.
In the properties of the ComboBox select that Query as the RowSource, and
for "Bound Column" choose 2.

OR

Create a Query based on the Table with the apporpriate information.
Concatenate the two fields you want into one field as follows:
[ID]&" "&[Name]
Save the Query.
In the properties of the ComboBox select that Query as the RowSource.

What do you mean by your second question, "Hod do I get the date field to
update a specified field when the form is accessed?" How do you get today's
date to populate a field? Or what do you mean. Please elaborate, I'd love
to help.