Run time error 3061 (1 Viewer)

solnajeff · Apr 10, 2019

I have a query which returns a single record based upon using DMax on one field and a lookup value from a form on another.

Run in isolation the query correctly returns a single record but when I try to use the query as a recordset it returns the above error.

The cause of the error is the lookup from the form, if it is replaced by a value then the query can be used without a problem. In all cases the form is open in form view.

The answers I have seen on other websites do not help and I am wondering if anyone has come across this before and could point me in the right direction

Many thanks

Jeff

theDBguy · Apr 10, 2019

Hi Jeff. See if using Leigh's Generic Recordsets could help with your situation.

MajP · Apr 10, 2019

I would get rid of the form reference in the query. Instead build the string

dim rs as dao.recordset
dim formValue as variant
dim strSql as string

formValue = forms("someForm").SomeControl.value
strSql = "Select .... from ... where ... = " & formValue
set rs = currentdb.openrecordset (strSql)

solnajeff · Apr 11, 2019

Hi

Sorry for the delay.

Many thanks for the suggestions i will try them out and see which works best.

Regards

Jeff

theDBguy · Apr 11, 2019

solnajeff said:
Hi

Sorry for the delay.

Many thanks for the suggestions i will try them out and see which works best.

Regards

Jeff

Hi Jeff. Good luck!

solnajeff · Apr 12, 2019

Hi

I have used MAJP's suggestion regarding variables and so far so good it is working correctly.

Once again thanks to you both

Regards

Jeff

Run time error 3061 (1 Viewer)

solnajeff

Registered User.

theDBguy

I’m here to help

MajP

You've got your good things, and you've got mine.

solnajeff

Registered User.

theDBguy

I’m here to help

solnajeff

Registered User.

Similar threads

Users who are viewing this thread