S
sameat
Please excuse my complete lack of knowledge.
I want my fom to ask me for which record to display when I open it.
How do I do that?
I want my fom to ask me for which record to display when I open it.
How do I do that?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick Brandt
Please excuse my complete lack of knowledge.
I want my fom to ask me for which record to display when I open it.
How do I do that?
A nice way to handle this is to add an unbound TextBox or ComboBox to the form
labelled "Go To...". Then you initially open the form displaying no record...
DoCmd.OpenForm "FormName",,,"False"
("False" is just shorthand for a filter that is never satisfied).
Then you use the AfterUpdate event of the unbound control to apply a filter that
is satisfied by exactly one record.
(if primary key field is numeric)
Me.Filter = "PrimaryKeyField = " & Me.GoToControlName
Me.FilterOn = True
(if primary key field is text)
Me.Filter = "PrimaryKeyField = '" & Me.GoToControlName & "'"
Me.FilterOn = True