form issue - parameter query

[verdes]

I have a parameter query that selects a group of records in a table based on the entered year. Let’s call the query – paramYearqry
paramYearqry is the control source of a form that puts the group of records on a tab/page on the form. Let’s call this form – yearRecordsfrm.
I have a different form (let’s call it – theCallingfrm) that has an on-click event to open yearRecordsfrm. When the event fires, I get the prompt to enter the parameter and the yearRecordsfrm opens correctly.
I want to enter the parameter year in a control on theCallingfrm so that the yearRecordsfrm opens without the prompt because it is using the year that was entered on theCallingfrm.
I can’t get it to work correctly. Please help!

 

[Trevor G]

You would open the form with the parameter and then go into design view, then open the query in design view. Then look to use the Expression builder where you have the year field and then in the Expression builder you would select the form and the field that you want to use.

 

[verdes]

Thanks Trevor,

But that didn't work. I just don't know what I'm doing wrong. I really thought the expression thing was going to work because I typed the form field name in myself and may have typed it wrong.

I appreciate your help. The form I enter the year on is open, but when the openform command is executed the new opened for does not display any of the records from the parameter... query.

The regular parameter query form opens fine when the openform command is executed. I just don't understand what I'm doing wrong.....

Thanks again

 

[bob fitz]

Can you post a copy of your DB in A2003 mdb format.

 

[verdes]

Forgive me for being so dumb....but how do I post the db to this forum

 

[bob fitz]

Click the "Go Advanced" button that is below the Quick Reply input space.
Then scroll down the page and click the "Manage Attachments" button.
Then follow the prompts to select a file and upload it.
Click the "Submit Reply" button.
See: http://www.access-programmers.co.uk/forums/faq.php?s=&do=search&q=attachments&match=all&titlesonly=0

 

[boblarson]

Click the "Go Advanced" button that is below the Quick Reply input space.
Then scroll down the page and click the "Manage Attachments" button.
Then follow the prompts to select a file and upload it.
Click the "Submit Reply" button.
See: http://www.access-programmers.co.uk/forums/faq.php?s=&do=search&q=attachments&match=all&titlesonly=0

We also have this under the Access FAQs section as a sticky:

How to Upload Your Database to the Forum

 

[verdes]

My database is too large. I stripped it down - and removed data. The zipped file size is 2.80......

I'm sad.

 

[verdes]

I hope I didn't post this twice....

The 2 forms I'm having trouble with is frmAppointments and frmAnnualConvAppt.

frmAnnualConvAppt has the parameter query as the control source.

 

[bob fitz]

I think the SQL for the convScheduleYear_qry query should be:

SELECT convSchedule_tbl.convscheduleNo, convSchedule_tbl.convscheduleName, convSchedule_tbl.convscheduleStartDate, convSchedule_tbl.convscheduleEndDate, convSchedule_tbl.convscheduleYear, convSchedule_tbl.convscheduleID, convSchedule_tbl.convscheduleHostpastor, convSchedule_tbl.convscheduleHostelder, convSchedule_tbl.convscheduleHostchurch, convSchedule_tbl.convscheduleNotes, convSchedule_tbl.convscheduleyearNo
FROM convSchedule_tbl
WHERE (((convSchedule_tbl.convscheduleYear)=[Forms]![frmAppointments]![ConvYear]))
ORDER BY convSchedule_tbl.convscheduleNo, convSchedule_tbl.convscheduleYear DESC;

 

[verdes]

I'm so happy!!!!!!!

It worked!!

Thank you so much!!!!!!!