Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cannot delete record

Status
Not open for further replies.

Joallyn

Technical User
Jul 26, 2002
44
US
I'm stumped. I have a continuous subform with a combo box ("Materials") that allows a user to choose which materials he used in a given project. The user then enters the number of these items

i.e., "Rebar" "24"
"PVC" "18"
"16d Nails" "100"

All fine. The problem comes when I try to delete one of the selections. For instance, if I remember that I didn't actually use rebar, and delete it, I get the error

"You tried to assign the Null value to a variable that is not a Variant data type."

How do I get around this???

thanks for the help in advance--

J
 
Question, "Is your combobox bound?; and what fields within your underlying table are compulsory entries?".

It might be that you're starting a record and not adding to one of the compulsory key fields. So when you lose focus on that particular record when trying to delete it, it won't allow it until all key fields are present (not null). And if you haven't lost focus on the current record then sometimes pressing Escape a couple of times will empty it. Just an idea.

Anyhow, I'd be very interested as to how you resolve this issue in the end...wish I could be of more help.
[yinyang]
 
The combo box _is_ bound; the tables are

tbl Materials
MaterialID (pk)
Material

tblActions
ActionID (pk)
ActionDetails

tblActionMaterial
ActionID (pk)
MaterialID (pk)
Quantity

Still puzzling over this one...

thanks for the reply,

J
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top