Search results

Beautiful, Works Perfect! Thank you so much!

Yes it is set to No.

Okay, now back to the initial problem. I changed the where condition to read [JobNumber]=[Forms]![frmProposalDetails]![JobNumber] it opens the form and it filters to a blank record instead. JobNumber is actually a text field (which I don't remember why I did that) I added in the &Chr(34) does...

Hey Bob, Thanks for your reply. The field is numerical and I have corrected the code although now I am receiving another error message. It is telling me invalid use of null on this line of code that is in the Sub Form_Current() 'If revision is checked make subform visible...

So, I have a datasheet form and in the double click event I have built this macro. I want to be able to double click the JobNumber and the detailed form open set to the specified job number. The double click event opens the Enter Parameter Value Window, once I type in the number it goes...

They are related in the relationship window. I figured it out though. On the Form's Properties you have to manually set Data/Filter and enter syntac and switch Filter on load to Yes. Problem Solved Thanks!

Hi All, I'm going to try to explain this with the best of my abilities. I am familiar with Access (running in 07'), but not so much with VBA. Ive been reading VBA for Dummies (just to give you an indication of where I’m at. So I have a navigation form "frmProposalDetails" in this form I have...