Copy textbox value into all empty records in field

[ericv]

Hi, I have a data entry form (continuous) based on a single table, which appends data to another table through a query.

This form has several filter buttons which helps the user to find the records he needs to enter data against.

How can I build a button so that when clicked, it will copy&paste a textbox value (on the same form) into all the empty records of a specific field in the filtered form? This is so the used doesn't have to copy a certain order several times over, but can do it via the textbox.

Thanks in advance.

 

[mike60smart]

Hi

Why not use a Command Button to create a Duplicate Record??

 

[ericv]

The table being filled in is half pre-populated, so the user doesn't actually add new records to this table, he only filters, adds data in a few empty fields, then his entries is copied over to another table, and the first one is cleared back to its original state.

So not sure, but don't think I can duplicate the record as new records is not being created (?)

 

[mike60smart]

Hi

Why are you copying the same data to another table??

 

[arnelgp]

Have a look at this sample.

 

[ericv]

Hi good question...reason for the setup is that the previous setup of 2 related forms where the user fills data into the subform did not have the format I was looking for. It must be a continuous form as there as so many entries, and the subform that is in the footer of the main form is just to fidly. It can work and perhaps as far as databases goes is better, but my users does not love computers and the despise filling in forms, so just want to make it as easy as possible for them...

 

[mike60smart]

Hi

It still does not sound right to use the process you are talking about.

A Main Form based on the Parent table and a Subform based on the related Table is the correct method.

Can you upload a zipped copy of the Db so we can see the table structures?