Form - redisplaying it with all records.

  • Thread starter Thread starter andy
  • Start date Start date
A

andy

Currently i link forms displaying in one form depending on what record
the cursor was in, in the last form, like this

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmIOSlot"
DoCmd.OpenForm "frmIOSlot", , , "[Nodeid]=" & Me.NodeID

what i would like is a "refresh" type button whereby all the records
on that form were displayed when it is clicked, not just the linked
records.
Anyone got any idea?
thanks
 
You could use the following code behind your 'Refresh' button:

me.Filter = ""
me.Refresh


Kel
 
it worked!
you beut!
Kel said:
You could use the following code behind your 'Refresh' button:

me.Filter = ""
me.Refresh


Kel


andy said:
Currently i link forms displaying in one form depending on what record
the cursor was in, in the last form, like this

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmIOSlot"
DoCmd.OpenForm "frmIOSlot", , , "[Nodeid]=" & Me.NodeID

what i would like is a "refresh" type button whereby all the records
on that form were displayed when it is clicked, not just the linked
records.
Anyone got any idea?
thanks
Click to expand...
Click to expand...
 
Back
Top