By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
462,115 Members | 733 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 462,115 IT Pros & Developers. It's quick & easy.

Looping through continuous form

P: 2
I have a main form (not bound to any data source) with a subform based on a query. The subform shows furniture parts according to the criteria specified on the main form. The purpose of the subform is for user to enter produced quantities.
To do this I've added a quan field to the subform that is not bound to any data. The problem is that whenever I enter a value in a record the same value appears in all the subform's records. The other way was to add a dummy field to a table, include it in a query and bind it to quan field - this however doesn't work since the recordset isn't editable (I guess - it uses 4 tables with relations between).
How can I achieve such functionality i.e. to be able to enter quantities for parts shown (then I would programmatically calculate the total looping through the subform's records). I work in Acc2000.
Jun 30 '06 #1
Share this Question
Share on Google+
1 Reply

100+
P: 179
Unfortunately, if you want to keep that quantity value different for each record, then you have to bind it to a field in a table somewhere. The reason you're seeing the same value in all subform records is because it is only being read from the form itself, and not being read from a table.

If you can only read from the tables in question (i.e they're not editable), then what you could try doing is creating another table, and bind the textbox to a field in that table. You may have to use a combo box, and refer to your table under "Row Source" in the properties of the combo box. I'm not 100% sure if this will work.

Good Luck.
Jun 30 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.