Using a Form to Show a Record and then Update fields

[Guest]

Hi
I have a form which contains a subform to show the details currently in my
table when and item is requested from a combo box.

Some of my fields in the table shown on my sub form have not been completed
as it is downe in different stages (this has to do with when the paperwork is
received).

Can someone please help to explain how I can update the field which is empty
when I have the required information using the form.

Master form is linked to a query and main table and is used to look up a
reference no.
Child form is linked to the main form and shows all the fields against the
reference no in Master form.

What I would like to be able to do is update a couple of fields which has no
data in it however it doesn't allow me too as they are bound.

Any ideas would be very much appreciated.

Thanks
Noemi

 

[Larry Daugherty]

It sounds like something wrong with the query for the subform. In
design view for the main form if you look at the at the properties of
the subform control you should see field names for Link Master Field
and Link Child Field that have the same meaning, usually the same
name.

Another thing is to check the subform independently by opening it as a
form. Try modifying records then. By whether you can or you can't
you'll have some idea in which direction the problem/solution lies.

From the fog of years gone by a couple of things nag at me. One is
updateable/non-updateable query. The other is from a similar post
back when Access 3.0 was in vogue. It seemed that the answer there
was that the query for the subform had to have the Primary Key of the
Master table referenced in the subform's query.

HTH

 

[Guest]

Hi Larry
You were correct, it seemed that I had not used the exact name in my field
on the subform, not sure how that happened but it works great now.

Thank you so much.

Noemi