Filtering subform records

T

TobyMace

Registered User.
Local time
Today, 15:54
Joined
Apr 13, 2018
Messages
65
Hi All,

I am looking to filter my subform records. Maybe.

I have two fields:
RER Number
Serial Number

My subform shows the RER Number of all the records in which that Serial Number has been entered before. However it shows the current parent RER Number also. I tried applying a filter to the subform:

Code: 
Me.Filter = Me!RER_Number <> Me.Parent!RER

But that then prevents any records being shown in the subform.

Any help is appreciated!
 
Why should the current parent RER Number NOT be shown?
 
Well that information is already available if you see what I mean?
Preferably I wouldn't like to duplicate information being shown.
If a user sees the same RER number on the parent from and sub form they may think there is a difference between the records. I'm trying to make it less confusing and more user friendly is all.
 
There has to be an answer but I need more coffee right now to get the brain to wake up. :D
 
I know the feeling well! I look forward to your reply!
 
The subform record source is Query1.

Query1 pulls values from TableA.

Parent form record source is TableA.
 
How about if you modify the SubForm query and use the Forms collection so the recordset does not pull records with RER equal to Forms.YourMainForm.RERcontrol?
 
Hi RuralGuy,

I'll have to try this tomorrow. 1000 things just hit my desk!

Many thanks!
 
Hi again,

Apologies for the delay!

I used:

Code: 
Dim rervalue As String
rervalue = [RER]

Me.PRQ.Form.Filter = "[Previous_Returns_Q].[RER]<>'" & rervalue & "'"
Me.PRQ.Form.FilterOn = True

And it seems to be working now!
I want the form to be in datasheet view and the subform results are shown as a subdatasheet. (Done that!)
But the value in the subdatasheet will only update when I click in there. Is there anyway to have in constantly refreshing the subdatasheet value?

Thanks.
 
You must log in or register to reply here.

Similar threads

A
Search box to find parts to add to job instead of a combo box
2 3
Replies
41
Views
689
Gasman
Gasman
D
Subform requery is starting a new record
Replies
4
Views
472
dullster
D
J
Sorting & Alerting User that Subform has more than 1 record
Replies
3
Views
229
Pat Hartman
P
A
Display a list of previous jobs with same serial number on current job form
Replies
13
Views
391
andymartin3186
A
D
Solved Open a report that filters off a form field
Replies
7
Views
657
dullster
D

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom