Search results

Thanks, Gasman. I'll have a read! mike60smart - at the moment I am just more curious now if this would work. But you are right, at some stage I will need to add more details about the company so it might makes sense to launch a new form instead of inserting into the table what is in the...

Right your suggestion makes a lot of sense and I may go that direction. What I currently have setup is a form that is connected to the tblCompany. I have a listbox that is tied to a textbox and in VBA I have this query. Me.ListBox.RowSource = "SELECT Company.CompanyName FROM [Company] WHERE...

Thanks, mikes60smart. That's exactly how my tables are currently structured. The problem I was dealing with was not how to link individuals to a company. But rather how to make a form to i) search for a company in tblCompany and then ii) have the option to add a new company to the tblCompany...

Thanks CJ_London! What did you mean by "depends on how your form is built"? Were there some details I could provide that would help? But I think I'll try the msgbox and see how it goes.

Hi All, I was wondering if there is a way in single form to search for an existing record and if that record is not found present the option to add a new record. I have the "search" part sorted using a text box and list box. But not sure how to "present the option to add new record if record...