Entering data in forms

[dizzyflossy]

Hi all - thanks for reading. I hope this isnt too much of a silly
question... here goes.
I am trying to design a database of medicines that have been allocated a
simple red, amber or green status.
I have managed to successfully put "combo" drop down boxes into the main
table to speed up entering data, and I have designed a form, for which I
would like to do the same thing. Trouble is, although when I click on the
down arrow to see the drop down list when in the form, I can see but not
select any of the options and it says "this is not updateable". The main
table is really big and I dont want to enter all the data this way, I wwant
to use the form to enter data. The form is made up of fields from two tables,
could this be a problem?
The two tables are linked by a relationship according to the drug name. Do I
need to create other relationships to enable me to enter data via the form?

I do hope this makes sense....

Kind regards, Hayley

 

[KARL DEWEY]

I have managed to successfully put "combo" drop down boxes into the main
table to speed up entering data,
You should not be entering data directly into the table.
Yes. What is the relationship of the two tables? Did you create a
relationship?

Post the SQL of the query used to feed the form. Open query in design view,
click on VIEW - SQL View, highlight all, copy, and paste in a post.

 

[dizzyflossy]

Hi there, thanks for your response. I did give the tables a relationship by
drug name. I have now given up and put all the data in the main table and
the form now works correctly, so I guess it was to do with having fields from
both tables. As I am no access expert, and it now works, I'm going to stick
with it!!!!
Many many thanks again for replying.

 

[Linq Adams via AccessMonster.com]

Two things

1) Tables should never be used for data entry! Too many things can go awry!

So moving your data entry to a form is the right way to go!
2) When you combine foelds from two or more tables into a single recordset,
you've created a query, and not all queries can be updated. Have a look
at
Allen Browne's article on this sugject, along with some workarounds he
gives:

http://allenbrowne.com/ser-61.html