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 / General 2 / May 2007

Tip: Looking for answers? Try searching our database.

Form show up in switchboard

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Chinny03 - 31 May 2007 18:36 GMT
When the user clicks a button such as "Add Record to Student Table" how could
I have that form show up in the same window as the switchboard.  How would I
do this with a query?  Thanks.
Wayne-I-M - 31 May 2007 21:04 GMT
Hi

You would need to have the buton as a control on a form not a query.  Set
the OnClick event to open your fom (as a popup) and filter it open at the
record you want to add the data to - you could select the student  from a
combo box of list.  Not as long as the primary field of the tudent table is
the bound column of the combo your could set the column width the 0 so you
would just be able to see the name.  If you you set the auto expand to yes
this would assist you if you have a large number of students.

Signature

Wayne
Manchester, England.

> When the user clicks a button such as "Add Record to Student Table" how could
> I have that form show up in the same window as the switchboard.  How would I
> do this with a query?  Thanks.
 
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.