dbexecute?

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

Guest

I have a subform that I always use. It is in datasheet format. The first
column is combobox CATEGORY. The Pull Down SHOWS "A","B","C","D","E","F"

I usually enter two records for "A", two more with "B", and two more with "D".
Sometimes I use "C", "E", or "F".

When I start a new record in mainform and then open the subrm for the first
time for that record, it would be a "nice to have" for the datasheet have six
records already populated......2 "A" records, 2 "B" records, 2 "C" records.

I could then just fill in the other fields...I could edit the CATEGORY to
"E" or "F" as necessary.

How could I automate such a process?

Would I have a FIRSTTIME flag, use dbexecute to SET CATEGORY using a LOOP?

Could someone show me skeleton code or give me a better idea?
 
Try using a RecordSet to populate the subforms data. Attach to a field
on the main form. Once you start entering data on the first field it
populates the subform with your data.
 
Back
Top