Continuous Form Entry Problem

[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

 

[Keith Wilby]

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

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

Keith.
www.keithwilby.com

 

[Guest]

No just a Beep. Neither queries have sums, counts or anything like that.

 

[Keith Wilby]

No just a Beep. Neither queries have sums, counts or anything like that.

Can you update records direct from the main form's query?

 

[Guest]

No I cant. I can update the sub form and its query but not the main form.

 

[Rick Brandt]

No I cant. I can update the sub form and its query but not the main
form.

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?".

 

[Guest]

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