I have form that has a Customer field which is a combo box. Further down the form, I have Combo box named Coding String. This form is used to fill a table, Trip Tickets. The Customer field is pulled from a list created by the Vendor List table. The Row Source coding is SELECT [Vendor List].[Vendor] FROM [Vendor List] ORDER BY [Vendor]; I have a Coding String table which contains both the Customer Name and the Coding String associated with it. It some cases, there will be multiple Coding Strings attached to a single customer.
What I would like to do is to have the form pull the Customer name from the form once it has been selected and use that to limit the available Coding Strings. I want only the Coding Strings attached to that particular Customer available in a Combo Box.
How do I accomplish this. I have tried several different things, but just can't seem to link the two items together.
Thanks
What I would like to do is to have the form pull the Customer name from the form once it has been selected and use that to limit the available Coding Strings. I want only the Coding Strings attached to that particular Customer available in a Combo Box.
How do I accomplish this. I have tried several different things, but just can't seem to link the two items together.
Thanks