Help with Access 2003 Forms

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
 
G

Golfinray

If the table or query that is the source of the form isn't editable, then the
form won't be either. Look for the arrow and asterisk at the bottom to be
highlighted.
 
J

Jamie

thanks for the quick reply.

The query wasn't editable. In the query I have linked another table
which includes an internal product in the query.

As a work round I had Access dump the query dynaset to a table and
used that for my form/sub form. That works as hoped.

Do I need to set-up relationships between the tables to allow the form
to work using the query? I away from setting up a relationship
because I didn't have a suitable primary key on either of the two
tables. Would it work if I created two auto numbered primary keys on
both tables?

I ask these questions as my next step is to export this data to a
large SQL driven database (if the form allows the users to amend the
records as expected), and I am expecting futher problems at point.

On a bit of a side note could any one recommend some online/paper
reading materials. I'm IT literate, just new to databases. I prefer to
learn the fundamentals foremost.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top