Display select record from cmdbutton on switchboard

  • Thread starter Thread starter Pamela
  • Start date Start date
P

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
 
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
 
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



NG said:
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


Pamela said:
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
Click to expand...
Click to expand...
 
Back
Top