Display select record from cmdbutton on switchboard

[Pamela]

I want a way to allow the user to open a form and display a specific
record...what is the easiest way to do this - my user is VERY novice and
needs it to be as simple as possible. I'm open to the idea of a pop-up form
on which to enter the search criteria but I have no idea how to link it
together. Thanks for any help! Pamela

 

[NG]

Hi Pamela,

you could put a combobox in the formheader which displays the name or
description field but return the ID field of the table.
Then all you have to do is write in the AfterUpdate event of that combobox a
little bit of code like:

me.filter = "[NameIDFiled] = " & me.cboNameCombobox
me.filteron = true

This example works if the ID filed is a number field. If the ID field is a
text field you should add the necessary quotes like:

me.filter = "[NameIDFiled] = """ & me.cboNameCombobox & """"
me.filteron = true

 

[Pamela]

Thank you. I tried creating the cbo but it isn't letting me update it...no
error message but it "pings" anytime I try to type in it. Here's my
Rowsource SQL:
SELECT [Assn Qry].ID, [Assn Qry].[Owners Name] FROM [Assn Qry];
I then have columncount at 2 w/ widths of 0";1". Thanks! Pamela

Hi Pamela,

you could put a combobox in the formheader which displays the name or
description field but return the ID field of the table.
Then all you have to do is write in the AfterUpdate event of that combobox a
little bit of code like:

me.filter = "[NameIDFiled] = " & me.cboNameCombobox
me.filteron = true

This example works if the ID filed is a number field. If the ID field is a
text field you should add the necessary quotes like:

me.filter = "[NameIDFiled] = """ & me.cboNameCombobox & """"
me.filteron = true
--
Kind regards
Noëlla

I want a way to allow the user to open a form and display a specific
record...what is the easiest way to do this - my user is VERY novice and
needs it to be as simple as possible. I'm open to the idea of a pop-up form
on which to enter the search criteria but I have no idea how to link it
together. Thanks for any help! Pamela