Retrieval of specific data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am currently setting up a contact management database. I have a listing
form which retrieves every single client that is on the database. From this
list which holds only limited information ie address details etc, I am
wanting to click on any client name whereby it will then retrieve ALL
information on THAT specific client including contact information, notes and
history etc. I would like this retreival to display all data about the
selected client in 1 form only once clicked.

Any help would be fantastic!
Thanks in advance!
 
Well, I don't think you can do so in a query, but you could in a form.

In the forms, (I'd make it a continuous form) you could build an event into
the "on current" event, or add a "details" button next to the record and add
a "click" event. The code would open a new form, filter to match the
current record, and contain all the data you want. You could then have a
"close" button on that pop-up form.

Rick B
 
I have created a new form, but how do I link the all of the exact data
already stored in the form containing all the client listing which is linked
to the client table into the new form? At the moment it is showing no details
in the new form. I have created a macro to open the new form should you
mousedown on a specific client, however the records are not appearing in the
new screen.....

Any help would be much appreciated.
 
Note: If you add a button to your form, the wizard will walk you through
this and create all the code for you. You could then copy and paste that
code into your 'click' event for the record, or wherever you plan to use it.


The new screen (form) needs to be your detail form. Build it just like you
would any other form. Include all the fields you want to see. Base it on a
form, or on a query. If opened by itself, it should cycle through all the
records in your database.

In the event that opens the form, you would do something like this...

DoCmd.OpenForm "DetailForm", , , "[ClientID]=" & "'" & Me![ClientID] &
"'"

Rick B
 
That should have said, "...it on a TABLE, or on a query..."




Rick B said:
Note: If you add a button to your form, the wizard will walk you through
this and create all the code for you. You could then copy and paste that
code into your 'click' event for the record, or wherever you plan to use it.


The new screen (form) needs to be your detail form. Build it just like you
would any other form. Include all the fields you want to see. Base it on a
form, or on a query. If opened by itself, it should cycle through all the
records in your database.

In the event that opens the form, you would do something like this...

DoCmd.OpenForm "DetailForm", , , "[ClientID]=" & "'" & Me![ClientID] &
"'"

Rick B

Kerry said:
I have created a new form, but how do I link the all of the exact data
already stored in the form containing all the client listing which is linked
to the client table into the new form? At the moment it is showing no details
in the new form. I have created a macro to open the new form should you
mousedown on a specific client, however the records are not appearing in the
new screen.....

Any help would be much appreciated.
Click to expand...
and
add
Click to expand...
have
a
Click to expand...
Click to expand...
 
Thank you very much! It worked!!

Rick B said:
Note: If you add a button to your form, the wizard will walk you through
this and create all the code for you. You could then copy and paste that
code into your 'click' event for the record, or wherever you plan to use it.


The new screen (form) needs to be your detail form. Build it just like you
would any other form. Include all the fields you want to see. Base it on a
form, or on a query. If opened by itself, it should cycle through all the
records in your database.

In the event that opens the form, you would do something like this...

DoCmd.OpenForm "DetailForm", , , "[ClientID]=" & "'" & Me![ClientID] &
"'"

Rick B

Kerry said:
I have created a new form, but how do I link the all of the exact data
already stored in the form containing all the client listing which is linked
to the client table into the new form? At the moment it is showing no details
in the new form. I have created a macro to open the new form should you
mousedown on a specific client, however the records are not appearing in the
new screen.....

Any help would be much appreciated.
Click to expand...
Click to expand...
 
Back
Top