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

Filling fields from a combo box in a continuous form

P: 72
I have a subform that's a continuous form. In it I have a combo box that fills a date field. It works great except for one thing. It fills in all the other date fields for each record and the combo box selection also. How can I apply this to only the record I'm on.

Here's my Row Source code for the combo box

Expand|Select|Wrap|Line Numbers
  1. SELECT [tblWorkOrder].[Job Number], [tblWorkOrder].[Completed Date] FROM tblWorkOrder ORDER BY [Job Number];
And here's the code for the date field control source

Expand|Select|Wrap|Line Numbers
  1. =[Combo12].[column](1)
Thanks for any help
Jun 16 '07 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
It sounds as if the combobox is an unbound control on the form. In datasheet view any change to this control will affect all instances of the control.
Jun 17 '07 #2

P: 72
It sounds as if the combobox is an unbound control on the form. In datasheet view any change to this control will affect all instances of the control.
Yes that is correct so I figure I need to use a bound combo box then.
Jun 18 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Yes that is correct so I figure I need to use a bound combo box then.
That should solve your problem.

Although to some extent it will depend on when the change is being triggered.
Jun 18 '07 #4

Post your reply

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