making a list

[kingsgambit]

Is it possible to select froma list and have a command called add, so the item is added to a record.
i.e if a customer wants a quote for parts, I could pick the parts froma list and create a record with these items, from that I could produce a report which would calculate the price.
Any ideas

 

[llkhoutx]

Certainly. When a part is selected merely add it to an "Order" table. This could be a temporary table or a table which contains all your orders.

 

[kingsgambit]

How could I do that, is it possible to click on a item in the list box and have some code add it to the table

 

[llkhoutx]

On the event of your choice run something similar to the following:

private sub YourEvent()
dim db as database
dim rs as recordset
set db=currentdb
set rs=db.openrecordset("OrderTable",dbopendynaset)
rs.addnew
rs!OrderNumber=me!txtOrderNumber
rs!PartNumber=me!. . .
etc. (picking what you need off your form)
rs.update
rs.close
db.close
set rs=nothing
set db=nothing
end sub