My Assistant
![]() ![]() |
|
|
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? |
|
|
|
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.
|
|
|
|
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 Top · Lo-Fi Version | Time is now: 19th June 2013 - 03:44 PM |