Stuck again! Bother! I got past the "missing reference" problem with your help. Now I have a "type mismatch" error. I went through every single filed in the table/query. I tried eliminating "risky" fields to see if it worked. I just cannot find what is causing this error. This is the line that comes up yellow: Set rsOld = CurrentDb.OpenRecordset("SELECT* FROM RecipeT WHERE RecipeID=" & RecipeID)
Sarah BlissOP
@Reply 7 months ago
Sarah BlissOP
@Reply 7 months ago
Kevin Robertson
@Reply 7 months ago
Is RecipeID a Number?
Since you are using 2 Recordsets I would recommend also defining a Database object.
Donald Blackwell
@Reply 7 months ago
I would also recommend checking you SQL statement that's highlighted. Specifically check the SELECT portion.
Sarah BlissOP
@Reply 7 months ago
Thank you both. I'll try those now.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Developer 24.
