HELP: RecordSet Clone

T

Tim

I have a continuous form that shows records for every employee, and I have a
RecordSetClone ComboBox in the header.

What I am trying to accomplish is when you open the form, all you see is the
RecordSetClone ComboBox in the header, and when you select an employee, only
those records will appear.

How do I code the VBA to achieve this?


Thank You
 
M

Marshall Barton

Tim said:
I have a continuous form that shows records for every employee, and I have a
RecordSetClone ComboBox in the header.

What I am trying to accomplish is when you open the form, all you see is the
RecordSetClone ComboBox in the header, and when you select an employee, only
those records will appear.

How do I code the VBA to achieve this?
Click to expand...


What is a "RecordSetClone ComboBox"? I know what those two
terms mean separately, but I can not imagine what they mean
together.

Typically, a filtering combo box's RowSource query is based
on the same table as the form, but only includes the
employee ID and name fields. The ID field is used as the
combo's BoundColumn so that the form's RecordSource query
can use a criteria like:

Forms!theform!thecombo
 
T

Tim

I am not looking to create a seperate form with the ComboBox, because my
users will be going from one employee to another to add in records.

The form I am created is not stagnate; it will be updated otherwise I would
have structed it the way you described.

If you look at www.datapigtechnologies.com and watch the tutorial on
RecordSetClones, the creator created a RecordSetClone but with a single form.
 
M

Marshall Barton

I still don't understand. What code are you using to get
the combo box to do that and why do you believe it's
necessary?
 
Top