S
SG
I have with the Help of Marshal being trying to resolve a really annoying
issue with a database I have been working on. Marshall has given me much
help but I think it requires someone having a look at the actual database in
order to resolve my issue. I do not mind making a donation if required in
order to resolve my frustrating problem.
My problem is as follows I have done the following as instructed by
Marshall.....
Arrgghhh, so it was a corrupted form. Well, stuff happens
:-\
What you are seeing now is the consequence of using a
dependent combo box on a continuous or datasheet form. The
reason is simply that there is only one RowSource property
and it is used to display all the rows. Unfortunately, the
workaround is sort of messy.
First, modify the form's record source query to join the
products table to your form's table on the ProductID field
and add the ProductName field to the field list.
Then add a text box to the form's detail section and bind it
to the product name field. This text box should display the
correct product name on every row in the form.
Now, to keep user actions from using the text box, add a
line of code to the text box's GotFocus event procedure:
Me.CBOProduct.SetFocus
When you get all that working, size and position the text
box on top of the text portion of the combo box.
BUT
If I add the Product Names Field my forms list and Create the text box
with it source being the product name you are correct it does display the
correct products BUT the Runtime Error Reappears exactly the same message as
before!!
If I then remove the product Name field from the tables source query the
error goes??!!
Your assistance is much appreciated!!
S
issue with a database I have been working on. Marshall has given me much
help but I think it requires someone having a look at the actual database in
order to resolve my issue. I do not mind making a donation if required in
order to resolve my frustrating problem.
My problem is as follows I have done the following as instructed by
Marshall.....
Arrgghhh, so it was a corrupted form. Well, stuff happens
:-\
What you are seeing now is the consequence of using a
dependent combo box on a continuous or datasheet form. The
reason is simply that there is only one RowSource property
and it is used to display all the rows. Unfortunately, the
workaround is sort of messy.
First, modify the form's record source query to join the
products table to your form's table on the ProductID field
and add the ProductName field to the field list.
Then add a text box to the form's detail section and bind it
to the product name field. This text box should display the
correct product name on every row in the form.
Now, to keep user actions from using the text box, add a
line of code to the text box's GotFocus event procedure:
Me.CBOProduct.SetFocus
When you get all that working, size and position the text
box on top of the text portion of the combo box.
BUT
If I add the Product Names Field my forms list and Create the text box
with it source being the product name you are correct it does display the
correct products BUT the Runtime Error Reappears exactly the same message as
before!!
If I then remove the product Name field from the tables source query the
error goes??!!
Your assistance is much appreciated!!
S