form help

[zaps via AccessMonster.com]

Hi there,

I have a combo box that lists all the email addresses of customers. The row
source is from a query where I used the email address field from the main
table, query property is set to show only unique values.

I then have another query that finds the corresponding Name, Address, Phone
number of the Email address selected from the combo box. I would like to
show the results of the second query in the form underneath the combo box
where the email address is selected. When I run the query, it works fine,
but I can't display the results. I tried using a text box, and in control
source typed =[name of second query]![Customer Name field]. I did this from
the Expression Builder. In form view, I get a #Name? message in my text box??


Thanks in advance,
Zaps

 

[Guest]

I am not sure exactly however here is what I would do.

I would set up the original form A to tie directly into the Email
addresses.

Place a combo box at the top of the form in he header and set the properties
so it will find the record selected on the form. You will be prompted for
this when you place the combo box on the header form.

Display the email address on the main form.'

Do a subform on the main form and set its record source to that of the NAMES
and phone numbers etc.

You must have a unique identifier in each table to match up here and now
your form should work.

You select a Email address in the frist combo box that displays the Email
Address and automatically synchronized is the name and address that
corresponds with the email address and as you move through the email address
these will change correspondingly......

Hope this helps.

otherwise to identify the subform for a text field you may have to use

Forms!MainFormName!SubFormName!Form!FieldName = Your Value..

I think that the right syntax

 

[zaps via AccessMonster.com]

Thanks for all the help Hansford. I did what you said, and it works, but I
have one problem. When I choose an email address from my combo box, it finds
the corresponding information (information is in the subform). I then close
the form, and when I reopen the form, the first record in the table email
address has changed to the last email address I was looking up?? How can I
fix this?
Thanks,
Zaps

I am not sure exactly however here is what I would do.

I would set up the original form A to tie directly into the Email
addresses.

Place a combo box at the top of the form in he header and set the properties
so it will find the record selected on the form. You will be prompted for
this when you place the combo box on the header form.

Display the email address on the main form.'

Do a subform on the main form and set its record source to that of the NAMES
and phone numbers etc.

You must have a unique identifier in each table to match up here and now
your form should work.

You select a Email address in the frist combo box that displays the Email
Address and automatically synchronized is the name and address that
corresponds with the email address and as you move through the email address
these will change correspondingly......

Hope this helps.

otherwise to identify the subform for a text field you may have to use

Forms!MainFormName!SubFormName!Form!FieldName = Your Value..

I think that the right syntax

Hi there,

[quoted text clipped - 12 lines]

Thanks in advance,
Zaps

 

[Guest]

SET THE Query property to return the data in ascending or descending order or
set the Filter property or OrderBY property to return the information as you
desire. It should set this when the form opens so it will not open on the
last record touched as it seems to be doing now...

Try this it should work for you....



--
Hansford D. Cornett

Thanks for all the help Hansford. I did what you said, and it works, but I
have one problem. When I choose an email address from my combo box, it finds
the corresponding information (information is in the subform). I then close
the form, and when I reopen the form, the first record in the table email
address has changed to the last email address I was looking up?? How can I
fix this?
Thanks,
Zaps

I am not sure exactly however here is what I would do.

I would set up the original form A to tie directly into the Email
addresses.

Place a combo box at the top of the form in he header and set the properties
so it will find the record selected on the form. You will be prompted for
this when you place the combo box on the header form.

Display the email address on the main form.'

Do a subform on the main form and set its record source to that of the NAMES
and phone numbers etc.

You must have a unique identifier in each table to match up here and now
your form should work.

You select a Email address in the frist combo box that displays the Email
Address and automatically synchronized is the name and address that
corresponds with the email address and as you move through the email address
these will change correspondingly......

Hope this helps.

otherwise to identify the subform for a text field you may have to use

Forms!MainFormName!SubFormName!Form!FieldName = Your Value..

I think that the right syntax

Hi there,

[quoted text clipped - 12 lines]

Thanks in advance,
Zaps