468,107 Members | 1,306 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,107 developers. It's quick & easy.

Continuous Forms ---- I must be NUTS!

Hello everyone. I thought I had a perfect plan but obviously I don't.
I created a continuous form which list all our company's inventory.
The Continuous Form has the Inventory Number, Description and Quantity
on Hand. The Continuous Form is based on a Query. That works great.
I placed an unbound text box on the form so people could enter a number
next to each inventory item that they may need for a project. You
would enter all the numbers hit update and have an inventory list of
all the items plus quantities you need for a project.
Buuuuuuuuuutttttttt when you enter a quantity in the text box I
created all the text boxes next to each inventory item gets filled in
with the same number. Have I approached this project incorrectly. Any
help appreciated.

Oct 31 '06 #1
2 1347
eighthman11 wrote:
Hello everyone. I thought I had a perfect plan but obviously I don't.
I created a continuous form which list all our company's inventory.
The Continuous Form has the Inventory Number, Description and Quantity
on Hand. The Continuous Form is based on a Query. That works great.
I placed an unbound text box on the form so people could enter a number
next to each inventory item that they may need for a project. You
would enter all the numbers hit update and have an inventory list of
all the items plus quantities you need for a project.
Buuuuuuuuuutttttttt when you enter a quantity in the text box I
created all the text boxes next to each inventory item gets filled in
with the same number. Have I approached this project incorrectly. Any
help appreciated.
Since the field is unbound, the same "field" is displayed in the form.

You will need to adjust your input method. You can add a field to the
inventory number. Most likely this won't work since you are also
displaying qtyonhand.

You may need another table. This would link to the project. Here you
could store the date entered, the emp that entered it, and the qty.
This will work better. If there's only a 1-1 correspondence that will
make it easier. Let's say tho you have ProjectA, and invoice item 123
was selected by Jack and he needed 5 and Bill needed 4...in otherwords a
1-many relationship, you could use a subform to display those. When you
go to a record, you'd requery the subform.

There's many ways to go about this...but not the method you want to use.
It's like if you have a list with a combo for customer contacts. On
each row you requery the combo to display the contacts for that
customer. Well, you select Jack on row1 and then go to row2 and select
Bill. Bill will now show in both. What some do is dbl-click on the
field, this calls another form where you can select the values you want,
then when it closes update the row you are on correctly.
Oct 31 '06 #2
1. Create a table with two fields, one being the inventory_id field, the
other the a field for the quantity ordered, in the front end mdb. Let's
call it inventory_order.

2. When the form loads, delete all existing values from inventory_order, and
use an insert query to insert the inventory_id field from the inventory
table into your inventory_order table.

3. Base your subform record source on the previous query you had, joined 1-1
with the new table on inventory_id.

--
Darryl Kerkeslager
Nov 1 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

By using this site, you agree to our Privacy Policy and Terms of Use.