Form Question

[Bandit]

I have limited experience in Access and have just begun working in the 2007
version. My experience is all self taught and on-line with MS Office
training. I have only worked with small projects that did not require
relationships and muliply forms and queries. I recently began a new job and
Access is the way to simply what they are doing and what needs to be done. I
downloaded the inventory management database template and have used this as a
guide to create one to suit my purposes. Some of the tables were not
necessary for our application and were thus deleted. Some just needed to be
adjusted a bit to meet our needs. I am stuck on just two things at this
point. I created a Purchase Order form using the info that we need based on
the template that I downloaded. I managed to change the variables to what we
need. This form had a subform within the form. On the subform it will only
allow me to enter one item for each Purchase Order. Sometimes we purchase a
number of items from the same supplier and thus use the same purchase order,
but under the current form I can only enter one item. Can anyone tell me
what I am doing wrong or missing? I want to be able to enter a number of
items within the same Purchase Order, same 4-5 items.

Thanks

 

[John W. Vinson]

On the subform it will only
allow me to enter one item for each Purchase Order. Sometimes we purchase a
number of items from the same supplier and thus use the same purchase order,
but under the current form I can only enter one item. Can anyone tell me
what I am doing wrong or missing? I want to be able to enter a number of
items within the same Purchase Order, same 4-5 items.

The Tables are fundamental; the forms are just windows, tools to manage data
in tables.

My guess is that you have the PO Number as the Primary Key of the table upon
which this subform is based, but since you don't specify any of your table
structures or form recordsources it's hard to be sure. What error message do
you get?

John W. Vinson [MVP]

 

[Dennis]

Make sure the subform is set to CONTINUOUS FORM.