Method for updating table from a search form.

[JulieAHop]

Hi

I'm currently working on designing a database to assist with building quotations.

I have 5 tables.

Customer
Contacts
Items
QuoteHead
QuoteLine

I have data entry screen which has a couple of combo boxes that deal with selecting the customer and contact, I have a subform for adding the quote lines, On the QuoteLine subform (a continuous form) I have a button that opens up a search form to assist with identifying an item, what I really want is to be able to select the item from the search form and be added to the quote line. I've really hit a brick wall with this.

I know it can be done just don't know how.

Any help would be greatly appreciated.

Thanks in anticipation.

Julie

[ranman256]

You could put a listbox on the parent form.
the listbox would show all items to pick from.
dbl-click an item in the list will run an append query to add it to the sub form.
docmd.openquery "qaAddItem2Quote"

You can also put a textbox to search the listbox for 1 item.

[JulieAHop]

Ranman256, you are a diamond. I was nearly there but was trying an update query instead. Doh!!
Thank you so much. It workied..... it's a miracle. I just need to get the append query to update the quote number from the data entry form header too.
Got any expert advice for me there?



Thanks so much.

Julie

[JulieAHop]

I have it sussed now.
Thanks again.

Julie

[ssanfu]

From your picture I see you have fields names "Description" and "Currency". These are reserved words in Access/JET and shouldn't be used as object names.
http://allenbrowne.com/AppIssueBadWord.html

Instead of "Description" I use "Desc", but I prefix it with an object.
But "Desc" is not very descriptive (Desc of what??), so I use something like "ItemDesc".


Something to be aware of. Using reserved words can lead to major headaches.......

[Missinglinq]

...But "Desc" is not very descriptive (Desc of what??), so I use something like "ItemDesc"...

Not only not very descriptive...but Desc is also a Reserved Word!

Linq ;0)>

[ssanfu]

How did I miss that???


Thanks Linq, for pointing that out.