Change Field Dependencies on Form

[JGalt90]

Hi, this issue has been posted here, usually suggesting cascading combo boxes, but I cannot get it to specifically work for my form. A change to OrderDetails_ProductID will correctly change the product name to the right product. For user friendliness I want to be able to put in the product name, and have the reverse happen (OrderDetails_ProductsID and Supplier ID change). This is the last thing holding up the DB, please help and I won't bother you people again.



Thank you

-J

[ranman256]

sub ProductName_afterupdate()
  [prodID]=dlookup("[prodID]","[tProducts]","[productname]=' " & [productname] & " ' "
end sub

[JGalt90]

Thank you, I am having a little trouble entering this, I am very new to Macros. I went into create macro and added a submacro then pasted it.

[ranman256]

This isn't a macro. This is an event of the box using vba.
the box a person enters the part name, triggers its update event ,(see properties, events tab, AFTERUPDATE.)
then the above code fills in the part#

[JGalt90]

Hi, I noticed there might be a ) missing, I tried it with that and without it in the properties sheet for Product name, OrderID, and the form as a whole and no changes occurred. I also entered it into the code builder in design view.

[June7]

Suggest eliminate spaces that follow and precede the apostrophe delimiters.

And yes, ranman forgot a paren.

[JGalt90]

Hi June and thank you so much for help in previous posts. I did remove the spaces too. : 0 Sorry

[June7]

Still not working? Want to provide db for analysis? Follow instructions at bottom of my post.

[JGalt90]

Still not working? Want to provide db for analysis? Follow instructions at bottom of my post.

Hi, I have removed the DB WITHOUT the added code in the properties sheet to reduce confusion. Ideally the code would allow me to change the Product name and change the ID's. Thank you.
BreadDB2.zip

[June7]

There is no code in this db that will change the product name or product ID in the textboxes.

Why don't you use comboboxes for selecting product?

Have you tried suggestion from other thread https://www.accessforums.net/forms/f...use-52097.html

Basically duplicate topic threads.