Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 7th, 2004, 11:16 PM
Authorized User
 
Join Date: Dec 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default Two forms at the same time

If I want a form for data entry and another also at the same time with some addl info from another table linked to the first one (the second is Read Only just to make some info available to the user at the time of data entry), how can I do this?
For example, I have a data entry form giving details of some invoices. Now the user has to refer to another table just for checking some old details pertaining to the same invoice. Those details are available in a table which is linked to the first one through a combo box (viz., the invoice no for the first form/table is taken out of the second table containing the old information)
Any ideas?
Thanks for your time and patience
Rao


 
Old December 8th, 2004, 03:23 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 129
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Rao,

Just make another form bound to the information you need and call it, say, from a command button. Suggest you read up on Pop Up forms in help.

Hope this helps,


Clive Astley
 
Old December 9th, 2004, 09:07 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

You can also have the other support form as a subform inside of your main form (say on the bottom or side). When you move from record to record on the main form, the subform (if linked properly) will automatically display the info right there without having to click any buttons.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old December 10th, 2004, 12:34 AM
Authorized User
 
Join Date: Dec 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks to both of you
I already worked out the first one
Now I will do the second which is so obvious that it did not strike me
Rgds
Rao

 
Old December 14th, 2004, 11:28 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post
Default

Have you tried locking the fields in question? (The ones that you do not want your users to change?)






Similar Threads
Thread Thread Starter Forum Replies Last Post
Time Shift time in minus time out lechalas Beginning VB 6 1 August 11th, 2008 01:56 PM
Adding User Forms at Run time RichRansom BOOK: Excel 2007 VBA Programmer's Reference ISBN: 978-0-470-04643-2 0 May 30th, 2008 11:49 AM
Updating controls on forms at run-time chipset VB How-To 5 September 25th, 2004 05:25 AM
Changing forms properties at run time Louisa VB.NET 2002/2003 Basics 5 January 15th, 2004 01:07 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.