A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Multiple Subforms Search



 
 
Thread Tools Display Modes
  #1  
Old July 5th, 2004, 01:07 AM
Kentucky5
external usenet poster
 
Posts: n/a
Default Multiple Subforms Search

Actually I have two dilemmas, I have a form with multiple
subforms on it and if the user ends one form and goes to
the next issue it does not start with the initial subform
it remains at the subform they were at with the issue they
just entered.

2nd I need a method to show the user on the main form what
subform already has data. My thought was if the subform
has data entered on it that the button should be bolded.
This would indicate to the user the buttons that are not
bolded do not yet have data entered and will ensure that
nothing is missed.

Any thoughts on either issue would be appreciated.

Thanks
  #2  
Old July 5th, 2004, 01:27 AM
Mike Painter
external usenet poster
 
Posts: n/a
Default Multiple Subforms Search


"Kentucky5" wrote in message
...
Actually I have two dilemmas, I have a form with multiple
subforms on it and if the user ends one form and goes to
the next issue it does not start with the initial subform
it remains at the subform they were at with the issue they
just entered.

2nd I need a method to show the user on the main form what
subform already has data. My thought was if the subform
has data entered on it that the button should be bolded.
This would indicate to the user the buttons that are not
bolded do not yet have data entered and will ensure that
nothing is missed.

Any thoughts on either issue would be appreciated.

If they are moving to a new record the subforms should all be blank.
Looking up an existing record in some matter should fill the subforms.
If this does not happen there is probably a relationship problem between
them.



  #3  
Old July 5th, 2004, 03:15 PM
kentucky5
external usenet poster
 
Posts: n/a
Default Multiple Subforms Search

When they move to a new record the subforms are blank but
the focus remains on the last subform that they entered
and that is not what I want. I want the main subform to
be the focus. Any ideas with regard to the 2nd issue? I
appreciate your help.



If they are moving to a new record the subforms should

all be blank.
Looking up an existing record in some matter should fill

the subforms.
If this does not happen there is probably a relationship

problem between
them.


-----Original Message-----

"Kentucky5" wrote

in message
...
Actually I have two dilemmas, I have a form with

multiple
subforms on it and if the user ends one form and goes to
the next issue it does not start with the initial

subform
it remains at the subform they were at with the issue

they
just entered.

2nd I need a method to show the user on the main form

what
subform already has data. My thought was if the subform
has data entered on it that the button should be bolded.
This would indicate to the user the buttons that are not
bolded do not yet have data entered and will ensure that
nothing is missed.

Any thoughts on either issue would be appreciated.




.

  #4  
Old July 6th, 2004, 06:23 AM
Mike Painter
external usenet poster
 
Posts: n/a
Default Multiple Subforms Search


"kentucky5" wrote in message
...
When they move to a new record the subforms are blank but
the focus remains on the last subform that they entered
and that is not what I want. I want the main subform to
be the focus. Any ideas with regard to the 2nd issue? I
appreciate your help.

Use setfocus to set the focus to the field you want in the oncurrent event.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup text with multiple search criteria analyst General Discussion 4 June 17th, 2004 01:38 PM
Problem using subforms in a multiple database project David G. Using Forms 0 June 10th, 2004 04:12 PM
Search Multiple Public Contact List Troy Ryan Contacts 0 June 10th, 2004 04:10 PM
multiple results search ruchir Worksheet Functions 3 March 4th, 2004 03:18 PM
Help needed with isnumber multiple search array formula J_Dodds Worksheet Functions 3 February 19th, 2004 01:04 PM


All times are GMT +1. The time now is 02:53 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.