Modify Form record without opening the form

  • Thread starter Thread starter Pakmanoncrack
  • Start date Start date
P

Pakmanoncrack

Hi,
I have a form for an access applications that has toggle buttons
used for approval of a design. I wish to put the approver's name and
the current date on the design form (different from toggle button form)
without opening it.

The problem I have is that the design form can have many records so I
have been opening the form, filering it for the specific record,
updating the pertinent fields and closing the form.

So basically, I need a way to update a specific record in a closed form
based on a value in the open form.
 
Forms don not store data, tables do. You are trying to update a record in a
table with some data (approver's name and date). This can be done using
code in a form, or you could do it using an update query. You could build
an update query to ask the user for the record number (or some way to find
the record to change). You would also ask for the approver's name. The
query could then find that record and modify it.

Or, you could code your form to do it. Of course, the form can't do
anything if you don't open it. Not sure what you mean by wanting to do
something in a form that is not opened.

Not really sure exactly how you want this to work. How will the user tell
the database to do this? Do you have a button on a form to click or are you
using a switchboard? Will you have the desired record displayed anywhere?
If so, you might just be able to grab the record from there, rather than
prompt the user for the number.

Would need more details if you need a better explanation.
 
Back
Top