copy value of field to find record in another form

[Caroline]

I’m a relatively new user of Access 2003 and was hoping that someone could
help me with a solution to this problem.
I have created a database that stores the contact and numerous other
personal and transactional details of clients. The database is based on a
single table (addresses). I have created a parameter query (search_query)
based on an input form (search_form) to allow users to find records matching
name and/or organisation and/or community. The results are then presented on
another form (search_results_form). This is all working well, but I what I
want to do now is allow the users to click on a command button (say ‘go to
record’) to take them to the corresponding complete entry in the address_book
form.
The process that I’ve been working through is:
- clicking on the command button copies/stores the reference number of the
active record (ref # which is a text field controlled by the query)
- the address_book form then opens and the reference number is used as an
input to find the record in the corresponding ref # text box field (which in
this case is controlled by the table addresses)
- the correct record is displayed
- at some stage the search_results_form should close
I feel that I’ve tried everything but am getting nowhere. Hope someone can
help.

 

[Mike Painter]

I'm a relatively new user of Access 2003 and was hoping that someone
could help me with a solution to this problem.
I have created a database that stores the contact and numerous other
personal and transactional details of clients. The database is based
on a single table (addresses).

If you only have one table and it contains transactional details (plural) or
even more than one phone number you need to consider having a contacts table
and related tables for details, phone numbers etc.


I have created a parameter query

(search_query) based on an input form (search_form) to allow users to
find records matching name and/or organisation and/or community. The
results are then presented on another form (search_results_form).
This is all working well, but I what I want to do now is allow the
users to click on a command button (say 'go to record') to take them
to the corresponding complete entry in the address_book form.
The process that I've been working through is:
- clicking on the command button copies/stores the reference number
of the active record (ref # which is a text field controlled by the
query) - the address_book form then opens and the reference number is
used as an input to find the record in the corresponding ref # text
box field (which in this case is controlled by the table addresses)
- the correct record is displayed
- at some stage the search_results_form should close
I feel that I've tried everything but am getting nowhere. Hope
someone can help.

Add a combo box to your form and select the option to move to a record based
on the result.
This may or may not solve your problem but in the afterupdate event it will
show you the code used to display the record you want.