query in form for data entry

[JaredNJames]

hi, have tried this in queries but i think i shoudl have put it here:

i have a query which when the user selects a value in a combo box it pulls up the other details of the item, such as price.

i have noticed though that if i try and enter a new item into the list, through the combo on the form and then enter a price, it gives me error 3101 (something to do with not being able to find the record.

i assume this is because it is trying to locate the chosen item of data within the main table and pull up a price.

is there any way around this.

jjames

 

[ajetrumpet]

Have you checked the "List to List" option in the form's properties??
And the "data entry" option too??
I wonder if these would work...