HELP: RecordSet Clone

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 
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?
 
Tim said:
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.
Click to expand...


Well that does help claify what you mean by your
phraseology. However, his little demo was for searcing for
a matching record in the form's record source dataset. The
way I read your question, you wanted to filter a continuous
form's data to just the matching records, which is why I
suggested what I did.

I don't know what you mean by your use of the word
"stagnate" in this context, but whatever it is, it doesn't
apply to what I said. There is nothing about my suggestion
that uses a separate form or anything that prevents the
form's data from being editied or new records added. Just
place the combo box in your form's header section and make
sure its ControlSource property is blank. The combo box's
AfterUpdate event procedure would only need the one line:

Me.Requery
 
Back
Top