Continuous Form Entry Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Not sure if i'm being a complete idiot but I've created a form which is
based on a parameter query. I've embeeded a subform which is also based on a
query. Using the main form we toggle between clients records updating the
subform, however We would also like to alter the value of a single field on
the main form.

Is this possible?

Ian
 
NoviceIan said:
Hi,

Not sure if i'm being a complete idiot but I've created a form which is
based on a parameter query. I've embeeded a subform which is also based
on a
query. Using the main form we toggle between clients records updating the
subform, however We would also like to alter the value of a single field
on
the main form.

Is this possible?

Ian
Click to expand...

Sure it is, do you get any error messages when you try?

Keith.
www.keithwilby.com
 
NoviceIan said:
No I cant. I can update the sub form and its query but not the main
form.
Click to expand...

Then you need to fix the query. Many queries that have more than one table
as input are not editable unless configured just right. A bound form where
you expect to edit data is not normally bound to a multi-table query, but it
can be made to work if the query is tweaked. See the help topic "When can I
update data in a query?".
 
Thanks for your help I remade the query one field at a time and managed to
tweak it just right, it works fine now. Many thanks
 
Back
Top