SELECT/Query Help...

[Rjc8513]

Okay, I'm lost.

I want to set up a form which will allow the
user to first select an e-mail recipient, then
select a file from one list, and then select a
file from another list.

The form contains a list box named lbxRecip,
a combo box named cbxFileOne, and a combo box
named cbxFileTwo.

I want lbxRecip to select from the table
RECIPIENTS, cbxFileOne to select from table
BASE FILES, and cbxFileTwo to select from table
ADDL FILES.

What do I set the form's Record Source to? Do
I use a SELECT statement in the After Update
property of the list box and the two combo boxes?

Is this even possible? Thanks.

Richard...

 

[Nancy2]

What table to you want to fill? If you have a table which needs the 3 fields, set the record source of the form to this table. This list/combo box row sources are used just for lookup.

 

[Rjc8513]

Nancy2,

Thanks for the response. What I'm trying to do
is take the user's file selections and e-mail
them to the recipient the user selected.

Okay, suppose, in addition to the above info I
provided, I have a table named tbl USER SELECT
with the fields RECIPIENT, FILEONE, FILETWO.

Now, I have made the form's Record Source
tbl USER SELECT. What do I do then?

Thanks.

Richard...

 

[Nancy2]

Bind your list and combo boxes to the cooresponding field in the table (right click the control, propeties, control source -- should be in the pull down list since you put the table as record source)

 

[Rjc8513]

Okay, I've bound the list box and the combo boxes
to the fields in the table. But now the form is
blank when I open it.

What do I do now? Thanks.

Richard...