nice sample...this is the closest thing to what I'm trying to do here...I was actually trying to populate the combo boxes themselves...I guess it's simplier this way...just esthetically less effiecient on an order form....
is it possible to have those 2 combo boxes to search the products table...
when I chose a stockNumber from the cbBox, it populates all the fields EXCEPT the Description.
and vice-versa for the Description....
weird...any ideas?
Thanks
Mina
What is the differance between Bound and Unbound?
Also, if I may, what do youmean by original data? Do you mean the data already stored in the Table?
I only need this for a lookup I already have a form that modifies and adds records into that specific table.
To actually point out what I...
BEAUTIFUL!!!
Ok so far so good....now here is the tricky part...I need to know if there is a way to have another DLookUp combo box?
example:
in the Sample DB frmComboPopulateMethod4, if I want to modify the ID txtBox into a comboBox. Then I would like to keep the current DLookUP code as it...
I'm sorry but I don't know what yo mean by "Open" the sample....I know you mean "DLookUp("UnitPrice","Products","ProductID = " & [ProductID])"
but how do I "Open" it?
thx
Mina
I'm still a novice Access user, can you give more details about this DLookUp? Whre do I enter this statement?
Do I have to modify any of my Forms? Tables? I believe I need to add an extra column in the Products table...
Thanks
Mina
I don't understand this statement....what is it that I have to change in it to make it work with my DB?
txtBoxDescription represents which txtBox...the one displaying what I chose FROM the comboBox?? I'm confused Zmr! :( sorry...take a look at this db from MS access templates...
One more problem!!! :(
How do I update the Combo Box I used to look for the product...basically...how do I interact with all the fields and update them as they change according to the selection made in ANY of them?
Thanks!
Mina
I think I found it on my own!
It's called populating a form from a combo box!!! :):):):)
I just need to adapt that to my db....thank you for all your help!!
Minadude
Thanks I'll keep looking...but can youtell me what exactly am I looking for? what is the term that explains what I'm looking for to do with my combobox?
Thanks.
I don't even see the 3rd option....when I drag a new combo box from the pannel I get the wizard and there are only 2 options in the first step....
Is there a way you can send me a sample database I can just implement in my own? I'm really desperate...I've been resarching this matter for weeks...
It's giving me an error massage saying that the database cannot find the macro.....I'm so confused! let me try to explain what I want again:
I have the following:
Table: Inventory
Fields: ID(PK),ProductID,ProductDescription,SalePrice
Table: Order
Fields...
Hello all! It's my first posting and I've been looking to get an answer to this problem for quite sime time.
I have a database with MS Access 2003 that contains an inventory items table, a customer table, with all the forms and subforms....my only problem is that when I select on the order...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.