Query Update

[George]

From my form I have several items that transfer directly to my query - but I
also I have several unbound items that I want o transfer to the same query -
is that possible, if so how is that done. In the query the fields that are
unbound to the form I tried to build an expression to link it to the text box
but no help...

 

[John W. Vinson/MVP]

From my form I have several items that transfer directly to my query - but I
also I have several unbound items that I want o transfer to the same query -
is that possible, if so how is that done. In the query the fields that are
unbound to the form I tried to build an expression to link it to the text box
but no help...

Why do it the hard way?

Just bind the fields to the form controls.

If you're trying to store calculated fields from the form into your
table, *don't*. Storing data which can be calculated from other fields
in the table is neither necessary nor good design; it wastes space (no
big deal) but much more importantly risks data integrity, since the
underlying fields could be changed making the calculated result wrong.

 

[George]

I should have explained it better. I have a form with a subform, the main
form has a few fields I want the info to stay in place as the data in the
subform is entered and saved to the table.

 

[John W. Vinson/MVP]

I should have explained it better. I have a form with a subform, the main
form has a few fields I want the info to stay in place as the data in the
subform is entered and saved to the table.

Please explain further. What are the Recordsources of the mainform and
subform? What's the Master/Child Link Field? Why are you entering data
on a subform which needs to (apparently) be stored in the mainform's
table? And what do you mean by "stay in place" - typically a subform
will remain static on one record while you fill in multiple subform
records?

 

[George]

Here is what I am trying to do - I tried to get the answer in the Forms
forum, but no luck. I initially created a form to collect aircrew write-ups
after they return from flight.
Normally they return with several write-ups so I don't want to have to enter
the basic info repeatedly so I have those fields on the main form, i.e. Pilot
Name, Date, Mission Call Sign, Etc. Then in a sub form the actual write-ups
plus some other fields.

Any ideas ?

 

[John W. Vinson/MVP]

Here is what I am trying to do - I tried to get the answer in the Forms
forum, but no luck. I initially created a form to collect aircrew write-ups
after they return from flight.
Normally they return with several write-ups so I don't want to have to enter
the basic info repeatedly so I have those fields on the main form, i.e. Pilot
Name, Date, Mission Call Sign, Etc. Then in a sub form the actual write-ups
plus some other fields.

If you would kindly answer my questions as posted, I might be able to
help.

If you do in fact have a form based on a table of constant data, and a
subform based on a table of "writeups", related one to many to the
first table, then you should not need to - in fact should not be
ALLOWED to - reenter any data at all.

Again: details of the application!!!! I can't see your tables; I can't
see your form; I can't answer your questions unless you tell me about
them.