Create button to lookup info in a table from same database?

  • Thread starter Thread starter elima
  • Start date Start date
E

elima

Hi, I need to create a database in access 2007 that looks for info in a table
and displays it in the form. Ex. The form created: one text box - author
name; next text box - author title. I need to have a button on that form
which looks up that info in my table and then display just those items on the
form. THank you, I am new at this and having the hardest time figuring out
how to do this operation. I'd really appresiate anyone that could help!!!!
 
Hi, I need to create a database in access 2007 that looks for info in a table
and displays it in the form. Ex. The form created: one text box - author
name; next text box - author title. I need to have a button on that form
which looks up that info in my table and then display just those items on the
form. THank you, I am new at this and having the hardest time figuring out
how to do this operation. I'd really  appresiate anyone that could help!!!!
Click to expand...

wow does this ever sound like a homework assignment.
Create a form, then filter the form with the button
 
[email protected] said:
wow does this ever sound like a homework assignment.
Create a form, then filter the form with the button
Click to expand...
You are right it is a homework assignment. The others on my team are more
lost than I am. When you say 'filter the form'. I'm not sure what you mean.
When I put the button on my form and the wizard starts to set up the button
do I cancel that?
 
You are right it is a homework assignment. The others on my team are more
lost than I am. When you say 'filter the form'. I'm not sure what you mean.
When I put the button on my form and the wizard starts to set up the button
do I cancel that?
Click to expand...

I'll give ya a hint. Dig around in the macros commands... then if you
want, you can convert the macro code to VBA by saving the macro as a
subroutine. Make friends with the help file. Really. I had to teach
myself VBA at school. I learned a ton. You just gotta dive in and
start trying things.
 
Back
Top