UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> filter/query for forms    
 
   
DerekC
post Jan 10 2006, 03:29 PM
Post #1

UtterAccess Veteran
Posts: 479



I have command button on frmFabrication that opens a form (frmSelect_Drawing) with which the users can specify the information they're looking for. Clicking OK on the frmSelect_Drawing has the following code:

Private Sub cmdContinue_Click()
Me.Visible = False
[Forms]![frmFabrication].Visible = True
DoCmd.ApplyFilter "qryDrawing_Select"
End Sub

frmSelect_Drawing populates qryDrawing_Select. However this code doesn't seem to be filtering frmFabrication. It doesn't return an error, it just doesn't filter the form. I'm new to using queries as filters...what am I doing wrong?
Go to the top of the page
 
+
dashiellx2000
post Jan 10 2006, 03:58 PM
Post #2

UtterAccess VIP
Posts: 9,209
From: Maryland



Have you tried closing frmFabrication and then reopening it to see if the filered data appears? If so, the form's data source needs to be requeried.
Go to the top of the page
 
+
DerekC
post Jan 11 2006, 08:45 AM
Post #3

UtterAccess Veteran
Posts: 479



I don't want the filter to appear every time the form opens, I just want it to filter the records for that user (then, once the user has left the form, opening the form again displays all the records).

I might be over-complicating the situation. Basically I want to find records in the parent form according to a parameter of the child form.
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 03:44 PM