J
Jamie
Hi.
I'm have a problem with a form I have created and I need some help to
spare me from losing my mind. I'm constrained to using MS Access 2003.
I am relatively new to Access and I would like to avoid VB if at all
possible. My problem in brief is that I have a form that displays data
from two queries. The form isn't allowing me to edit the records.
In more detail:
Database:
-a table with imported excel spreadsheet data,
-a query (x) to look up a stock code from another table
- a form (with sub form) displaying the data in readable manner
I have a form containing a sub form. The main form has a list box with
a list of reference numbers (obtained from a query). The sub form
displays related data fields from a similiar query with a WHERE clause
ensuring it displays only the records that match the reference number
selected in the host form.
The form works in once sense in that it displays the correct
information from both queries. However I am unable to edit the records
in the form. Can anybody help explain the requirements/logic needed to
get this type of form working.
I appreciate this is a bit vague. I didn't want to overload the post
with (possibly irrelevant) info, I can provide more specific
information, I just wanted to ask if I am missing something
fundamental rather than more specific settings. I have checked that
the host and sub forms data properties (i.e. allow edits, deletions,
etc) and all are set to yes.
I hope some one can offer some advise as this is driving me mad.
Thanks
Jamie
I'm have a problem with a form I have created and I need some help to
spare me from losing my mind. I'm constrained to using MS Access 2003.
I am relatively new to Access and I would like to avoid VB if at all
possible. My problem in brief is that I have a form that displays data
from two queries. The form isn't allowing me to edit the records.
In more detail:
Database:
-a table with imported excel spreadsheet data,
-a query (x) to look up a stock code from another table
- a form (with sub form) displaying the data in readable manner
I have a form containing a sub form. The main form has a list box with
a list of reference numbers (obtained from a query). The sub form
displays related data fields from a similiar query with a WHERE clause
ensuring it displays only the records that match the reference number
selected in the host form.
The form works in once sense in that it displays the correct
information from both queries. However I am unable to edit the records
in the form. Can anybody help explain the requirements/logic needed to
get this type of form working.
I appreciate this is a bit vague. I didn't want to overload the post
with (possibly irrelevant) info, I can provide more specific
information, I just wanted to ask if I am missing something
fundamental rather than more specific settings. I have checked that
the host and sub forms data properties (i.e. allow edits, deletions,
etc) and all are set to yes.
I hope some one can offer some advise as this is driving me mad.
Thanks
Jamie