adding new record in a sub-form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an order/sub-order form. In the sub-order form, if the user types in
an item that is not in the table, I would like to offer the user a choice to
add it. I would like for the user not to type in the info already existing
(item name). I would like to open the add item form with the item name and
let the user add the rest of the info only. Also, once this is done, I would
like to populate the sub-order form with the item that has been added. I
have looked at the recipes database but, it does not do exactly what I want.
Any ideas?

Thanks
 
I have an order/sub-order form. In the sub-order form, if the user types in
an item that is not in the table, I would like to offer the user a choice to
add it. I would like for the user not to type in the info already existing
(item name). I would like to open the add item form with the item name and
let the user add the rest of the info only. Also, once this is done, I would
like to populate the sub-order form with the item that has been added. I
have looked at the recipes database but, it does not do exactly what I want.
Any ideas?
Click to expand...

Use a Combo Box to insert the item, and use the combo's Not In List
event to open the "Items" form to add the new item. Look up "Not In
List" at http://www.mvps.org/access for sample code.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top