Create records automatically

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

Create records automatically…

Hi all again :-)

I want to create 7 records everyday. Each record contains a different value
from a combobox. Is it possible to do this with a command?

Thanks again for all help and suggestions received

Ciao!
 
Create records automatically…

Hi all again :-)

I want to create 7 records everyday. Each record contains a different value
from a combobox. Is it possible to do this with a command?

Thanks again for all help and suggestions received

Ciao!
Click to expand...

You'll need to explain a bit more. Why seven automatic records? It's VERY rare
that one would need to create automatic records that don't get subsequently
edited; will these? What's the rowsource of the combo box? What table do the
records go into? WHICH seven records - how can the program determine?

More info please!
 
Hi John

I create 7 different type of records (Table A) every day. They all look the
same but for the difference of the option in the bounded combobox (Table B)

1 record for combox option 1
1 record for combox option 2 etc etc

The records do get edited, but at a later time of the day. The reason is
because they have to be done...otherwise i forget to do all seven records...

Imagine that you have to fill in 7 forms every day...they all contain the
same data but the differnce is the Header...

Thanks!
 
Hi John

I create 7 different type of records (Table A) every day. They all look the
same but for the difference of the option in the bounded combobox (Table B)

1 record for combox option 1
1 record for combox option 2 etc etc

The records do get edited, but at a later time of the day. The reason is
because they have to be done...otherwise i forget to do all seven records...

Imagine that you have to fill in 7 forms every day...they all contain the
same data but the differnce is the Header...
Click to expand...

I'd ignore the combo box and run an Append query appending the seven records
from the combo box's rowsource table.

Again... *I cannot see your database*.

I have no idea what table you're filling, what the combo box contains, what
you mean by a "header", etc. so I'm really groping in the dark here. But I can
say that a Combo Box is a *display tool* and not a data repository; records
exist in the table, not in the combo box, so the table is where you'ld go to
get the records for appending.

Also in my experience empty "placeholder" records added to a table are very
easy to overlook; they have a nasty way of never actually getting filled in.
 
Back
Top