Open a second form to that uses data queried and selected on the first form

[graccess]

Disregard my last post. Sometimes keeping it simple works better... I used a simple double click command on each field name and created a form based on the query. I had to make the form modal because I can't seem to requery the second form or fresh it unless I close and reopen it but that actually works fine with the workflow. I'm not sure exactly why the form works correctly now populating based on what I clicked though. Thanks again for your time and assistance!

[ItsMe]

When you are testing code created in VBA it is a good idea to click "Debug" when there is an error and make note of the first line of code that caused the exception.

[graccess]

Well I'm back... it worked well until I realized the 2nd form wasn't effectively displaying the clicked record from the 1st form. Didn't have enough data stored to pick it up until now. So I'm back to using the code you showed me. I tried implementing it but I'm receiving the error 2465, application defined or object-defined error. See post #15 for my updated code. Any idea where I could be going wrong? thanks.

[ItsMe]

When you are testing code created in VBA it is a good idea to click "Debug" when there is an error and make note of the first line of code that caused the exception.

[graccess]

Apologies. Should have included that. It's getting hung up on the If statement.
If Forms!frmUserResearch.Forms.[cboRTicker].Value = Null Or Forms!frmUserResearch.Forms.[cboRIndustry].Value = Null Or Forms!frmUserResearch.Forms.[cboRSubsector].Value = Null Then

The cbo fields are my filter combo box controls from the main form.

[ItsMe]

Give this a try. The code I wrote out would be more appropriate for subforms and is not correct. Thanks for testing it.

If Forms!frmUserResearch.[cboRTicker].Value = Null Or Forms!frmUserResearch.[cboRIndustry].Value = Null Or Forms!frmUserResearch.[cboRSubsector].Value = Null

Also, you will need to remove FORMS after the form name in the other lines

Forms!NameOfMainForm.NameofControl1.Value

[graccess]

Getting a syntax error on a couple of the fields, 3075 (missing operator) in the query expression. I think we're referencing these fields as numbers but they're actually text values. assuming that's causing the error. how would you rewrite the code to reflect text?
Also, in the new form, I'm currently using as the record source for the form my query which runs on the 1st form. Is this correct or should it be left blank?

[ItsMe]

I do not understand what this means.

"Getting a syntax error on a couple of the fields,"

Is there VBA that is causing the error or is it a query object? If it is VBA show at least the one line of code that is causing the error or a block of code and indicate which line within the block is causing the error.

[graccess]

run time error 3075.
'syntax error (missing operator) in query expression '[CompanyID] = 17 and cboRTicker = AAPL AND cboRSubsector ='.

thats the full error. i'm getting this when i run the double click command event.

[ItsMe]

I am going to guess that the following is part of the error msg associated with error type 3075

'[CompanyID] = 17 and cboRTicker = AAPL AND cboRSubsector ='.

I will take another guess that if you continued with the "Debug" option it will take you to some VBA where you are applying criteria to an object. If this is the case, you will need to know which line(s) of code need to be fixed.

If there is not a debug option then I will have to guess again and say there is a parameterized query that is not functioning correctly.

I will consider the guess that there is an issue with the VBA. So, you will need to fix the VBA. Perhaps the VBA is set up to handle numbers and not text (as you mentioned). Text needs to be enclosed in quotes. You can concatenate quotes into a string that includes your control(s)/variable(s).