Look Up Fields Display

  • Thread starter Thread starter Tim Leach
  • Start date Start date
T

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
 
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

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).
Click to expand...

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

Tim Leach
 
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>
 
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.
 
Back
Top