populate sub-form using drop-down

[clayton ledford]

Hello,

I have a form that is not linked to any tables. I have added a sub-form
(data-sheet view) linked to the table that i want to update information in.
Most fields will be manually updated. However, two fields will be the same
for all records (ultimately appended to a larger table where those fields
will be different from other records).

For the purpose of my form, is there a way to update all records in the
sub-form for that specific field using a drop-down list located on the main
form?

Or... any other suggestions to accomplish this so the user doesn't have to
update each field with the same info.

Thanks,

Clay

 

[Jeanette Cunningham]

Hi clayton ledford,
maybe a default value would be easiest here.
Set the default value for these 2 controls and the data will be
automatically entered for them.

Or you could put a button on the form.
The button would have code that runs an update query ( or append if that is
what's needed).
You can create a saved query or you can put the sql of the query into vba.
Your button runs the query like this-->
Dim strSQL as String
strSQL = yadda etc
CurrentDb.Execute strSQL, dbFailOnError