Search results

I understand but I don't think i've explained myself well. I am adding a whole new record. I am populating every field in every table. If the supplier for the item I'm adding does not exist in the Suppliers table then I'm adding a new supplier to that table. If the supplier for the item I am...

It will be a single item per combo box or enter new value. I thought the main benefit to combo boxes was that you could select OR add a new value without referencing another form. What I'm having problems getting my head round is adding a record that references multiple tables. Sometimes it...

I have four tables with unique records as shown below. I'd like to add a record for a new item to the database by selecting the values from combo boxes for Supplier, Item and Unit. If the values do not exist the user would then type in a new value. SuppliersItemCode and Cost would always be...

RG, I worked with the db you sent back and got everything working the way I want and learned a great deal from it as well. Thank you for your time and effort.

RG, I owe you one. My specialized subjects are poker (all varieties), Exchange Server, all windows server and desktop platforms and networking. If I can ever repay you in kind please let me know. That is exactly what I wanted to do. All I need to do now is to refine it so that the unit combo...

If I can get the combo box synch working I can move onto trying to get the matching records to display. I'm going through that article you mentioned, it is very good and explains each bit of the code very well. Fingers crossed.

RG you are a star. I attached the db a couple of posts up. I don't even know if this is the easiest way to do what I want. I want to have the user select an item from the first combo box, which then populates the second combo box with units pertaining to that item. Then when they select a...

Thanks RG, i'll have a look

Thanks for taking the time RG. This shows that I know nothing about VB. I thought that Me.Items was referring to the Items table not the combo box name. I'm about ready to give up though as I cannot get it to work. It compiles fine now after I made the change you pointed out, but that alone...

I'm pretty hopless with VB but I am trying very hard (hours spent on this forum reading code I only slightly get the gist of) to implement a form that takes input from two synchronised unbound combo boxes and then displays records matching the input in a sub-form in datasheet mode. I'm failing...

Thank you very much for taking the time. I was getting there but you've clarified that very nicely thank you. Damn I wish I had slept in every SSADM class at college 14 years ago. Muchly 'preciated.

I really suck at table design and coding, and access. I'm a techie that usually stays away from all this development stuff; it makes my head hurt. I'm a lot happier knee deep in an Exchange migration than developing even the most basic of databases as I suck at it (think I mentioned that...