Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / March 2007

Tip: Looking for answers? Try searching our database.

Visible/Invisible text boxes

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Don - 14 Mar 2007 12:10 GMT
Using A2003 I am creating a new contacts database for my employer. I have a
couple of "special" features I would like to incorporate onto the main
Contacts form.

a, I have set the Shipto text boxes to invisible on form current and if the
Shipto Details checkbox (unbound) is ticked, the fields become visible for
data entry. This works as expected but what I'd like to have happen when the
form is opened is if the selected contact has Shipto info previously stored,
the Shipto textboxes will automatically appear as visible.

b, Textbox default value. Further to the above, how would I go about using
the mailing address details as the default Shipto address details once the
Shipto textboxes are visible?

Many thanks in advance.......
Don
missinglinq - 14 Mar 2007 13:33 GMT
Question A: You need code (probably the same you're already using to make the
text boxes visible) in the form's Form_Current event. As you move from record
to record this will set the visibility accordingly

Question B: I assume you only want the Shipto data to be the same as the
mailing data some of the time. I would:

1) Set up a command button; set up its visibility just like the Shipto text
boxes

2)  When it's clicked have

Me.ShiptoAddress = Me.MailtoAddress
Me.ShiptoCity = Me.MailtoCity
Me.ShiptoZipCode = Me.MailtoZipCode

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.