Look Up Fields Display

[Tim Leach]

I am trying to use a lookup field which shows the city stae and county for
a zip code. I have the lookup correct. When you enter the zip code the zip
code box will show all the information but it will only display the zip
code. I would also like to print the multiple fields on the report. Can you
help with this please?

Thank You
Tim Leach

 

[Jeff Boyce]

Tim

You posted in a 'forms' newsgroup. How does "print ... on the report"
relate to a form?

If you add unbound textboxes to a form, you can use the AfterUpdate event of
the combo box to fill those textboxes, with something like:

Me!txtCity = Me!cboZipCode.Column(1)
Me!txtState= Me!cboZipCode.Column(2)
Me!txtCounty = Me!cboZipCode.Column(3)

where City, State and County are the 2nd, 3rd, and 4th fields in the source
of your combobox (the Column() method uses zero-based counting).

 

[Tim Leach]

Tim

You posted in a 'forms' newsgroup. How does "print ... on the report"
relate to a form?

If you add unbound textboxes to a form, you can use the AfterUpdate event of
the combo box to fill those textboxes, with something like:

Me!txtCity = Me!cboZipCode.Column(1)
Me!txtState= Me!cboZipCode.Column(2)
Me!txtCounty = Me!cboZipCode.Column(3)

where City, State and County are the 2nd, 3rd, and 4th fields in the source
of your combobox (the Column() method uses zero-based counting).

Thank you for the information and I apologize for posting to the wrong
group.

Tim Leach

 

[Jeff Boyce]

Tim

Not looking for an apology, trying to understand the context of your post.
Hard to offer relevant suggestions on how to replace a windshield wiper
blade if I'm told the vehicle door doesn't close completely... <g>

Jeff Boyce
<Access MVP>

 

[Tim Leach]

Your advise was right on. That worked fine. What I meant by "print on the
report" was that I would also need that information to print out on a
report. I did not know how to make those fields show up on the report, but
I figured it out. Thanks for the advise.