SetValue

  • Thread starter Thread starter Audrey
  • Start date Start date
A

Audrey

I have created a request form and have a button that runs
a macro to open a table in data entry mode to set the
values of four fields based on the data entered on the
request form. I am not using the "=" sign in the
expression fields in the macro. How do I grab the data
from the four fields on my request form to begin a new
record in my other table?
 
This is not the best way to do this. Use a query to add or update data in
your table, don't edit the table directly.

A query can read the values from your form and use them as the source of the
data for the new/edited record.

Please post more info about your setup and we'll go from there.
 
Hey Ken,

I read your message this morning. I posted the message
about creating a macro to set the value of fields in
another table. Here's the deal... I am creating a request
form but I have to split it up into five tables. The
primary request data is entered on the first screen. Then
the user pushes a button to make selections on another
form (there are four buttons, one for each additional
table). I wanted to make them subforms but they are so
big (lots of little buttons) and I don't want to make the
one form look like a monster. I did look up on microsoft
about making a toggle button to display subforms but I
still need a way to put the contents into the four fields
for the four other tables. I know it sounds redundant to
have duplicate information in four tables, but in some
instances the main field will be blank (for new requests
in lieu of changes or deletes) and I have to have a way
of making the records unique (the primary request form
has an autonumber which is one of the fields I want to
copy to the other tables). I am also trying to set it up
so if the keeper of the database opens up any table
outside of the menus, she will see that the record
applies to a specific person - not just a number.

Sounds confusing but I know there is a simple answer!
 
No, actually the design of your setup sounds as if there is not a "simple"
answer. Likely this is because of your design, not because of what you want
to do.

How are the five tables related to each other (assuming that they are)? Are
you putting the exact same info in each table?

Please post some examples of the data that you are actually displaying and
selecting on the forms, info re: the table structures, etc.
 
Back
Top