Recent content by 2ShotLatte

Fo'gitaboutit. Word out the problem - was missing last bit of work WHERE (((tblStaff.HallID)=qryHall())) OR ((([tblStaff].[HallID]=qryHall()) Is Null));

Greetings I have a query that uses a public variable (varHall). The query returns only records where tblStaff.Hall and varHall are equal. I also want the query to return all records if varHall is null. Here's what I've done so far, but I'm stumped after that. Select tblStaff.StaffID...

I have a main form (Form1) with a subform. Subform displays selected data from Table1. The user would click on a command on Form1 to open Form2. Form2 and Subform use Table1. On Form2, the user would enter all data then close the form. Problem is Subform does not update/refresh. Any thoughts...

This worked for another fellow - Private Sub Form_DblClick(Cancel As Integer) DoCmd.OpenForm "Form_Name_to_Open", , , "[Key_ID]=forms!Form_Name!Key_ID" End Sub

Glad it worked. Good luck with the rest of your project.

I have a form, frmRA. Users open form and select an employee from a combobox (made using the wizard, Combo86) this updates frmRA with employee data. frmRA has a subform, subfrmNote, that lists notes on an employee. Users can double click, which runs an On Double Click event (DoCmd.OpenForm), a...

If I get what you're saying, you want to double click on a row in a subform to pull up information. I've use this on the "On Double Click" event. Private Sub Form_DblClick(Cancel As Integer) DoCmd.OpenForm "Form_Name_to_Open", , ...