Access - forms data add/retrieve (1 Viewer)

New access user - please help!!!
1.) I have used a combo box with NotInList event to add to combo box list and this works but doesn't update form details when i select this newly added list member

2.) I have a products form with a view button with on click event to open a browsing form. On the browsing form i can then double click and move selected part number to main form but when i try to access details i get error '3022'.


[This message has been edited by silky (edited 10-23-2001).]

1) You need to requery the combobox and you may also need to requery the form.

2) The message says that you are trying to insert a duplicate key value. From your description it doesn't sound like you're trying to insert a record, however, Access seems to think that you are. Check your code.

Pat

Thanks for you reply

Which event do I need to requery in - I tried this in the after update on the combo box but it seemed to create circular reference.