Variables in Query

  • Thread starter Thread starter PeterM
  • Start date Start date
P

PeterM

OK... I have a form that can edit my calendar table directly. When you click
on the calendar, it calls FormA for editing. You can also call FormA from a
generic search form that I have setup. I have setup queries for each
occasion. Query1 retrieves everything based on the Calendar entry clicked.
Query2 retrieves everything based on the Search entry clicked. If I'm
calling FormA from the calendar I set the recordsource is set to Query1... if
from the search form I call Query2. I pass a value to FormA using the
openargs to differentiate which form is calling the query.

My problem is that Query1 is opened by FormA for editing and Query2
retrieves all of the columns but won't let me edit the data in form. I get a
THE COMMAND OR ACTION (SAVERECORD) ISN'T AVAILABLE NOW error message. Below
are the Queries. Can anyone please help?
Thank you.

Query1
SELECT Appointments.*
FROM Appointments
WHERE (((Appointments.AP_Date)=forms!appointments!tb_date) And
((Appointments.AP_Type)=forms!appointments!tb_type) And
((Appointments.AP_Start_Time)=forms!appointments!tb_start_time) And
((Appointments.AP_End_Time)=forms!appointments!tb_end_time) And
((Appointments.AP_With_Whom)=forms!appointments!tb_with_whom));

Query2
SELECT Appointments.*
FROM Appointments
WHERE (((Appointments.AP_Date)=forms!findit!txtdate) And
((Appointments.AP_Type)=forms!findit!txttype) And
((Appointments.AP_Start_Time)=forms!findit!txtstart) And
((Appointments.AP_End_Time)=forms!findit!txtend) And
((Appointments.AP_With_Whom)=forms!findit!txtwithwhom))
ORDER BY Appointments.AP_Date;
 
There's nothing like putting out a question on the internet to make the
answer immediately and painfully obvious the second after you hit the send
button.....
 
Back
Top