need certain form data to repeat for several records

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

Guest

I have created a form where certain data will need to be repeated for several
records. I have found the ctrl(') command, but am looking for something
similar to an on and off box, because there are several fields that will have
to repeat.
 
A different approach would be to use the form's BeforeUpdate event to reset
the Default Value property of those controls. You could reset the Default
each time, and write over any values that you didn't need to be the same.

Also, if you are entering a lot of records with duplicate field values,
perhaps your data structure could use a bit more normalization...?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
If you mean repeating the same data in more than one control on the form,
you can add extra controls to the form and set the control source to the
same control source as another control on the form. If you mean repeating
records, add a checkbox to your table. Set up a method to check those
records you want to repeat. Base your form on a query designed to repeat
those records that are checked.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
I am so new to this that I am not sure what you mean. I need a template where
I might have 10 new records of which 7 will have the same informaiton in 3
out of 12 fields. I do not want to have to type the information for those 7
records in for each field.

I don't know what you mean by normalization.

I have seen databases where there are check boxes beside fields that can be
checked if that data remains constant, leaving the unconstant field uncheked
for manual update. Ultimately that is what i am trying to accomplish.
 
This is exactly what I am trying to do (as you state below... "If you mean
repeating
records, add a checkbox to your table. Set up a method to check those
records you want to repeat. Base your form on a query designed to repeat
those records that are checked".), but I only want certain protions of a
record to repeat into the next record. Is there a help topic that will
instruct me how to build a form based on a query? My current for is based on
a table. Will I have to redo the form?
Thank you for your assistance.
 
The answer to your question is NO. Create your query. Then open your form in
design view. Click on the Properties button on the menu and the Properties
dialog will appear. Go to the Data tab and change the RecordSource property
to the name of your query. You can click on the downarrowq at the left and
select the query from the list.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Back
Top