PC Review


Reply
Thread Tools Rate Thread

Re: Sorting records in a form

 
 
Jeff S via AccessMonster.com
Guest
Posts: n/a
 
      15th Sep 2005
I don't understand how to implement this idea:
I put an unbound combo on the main form that allows to select the product.
Then how do I "set the Subform's Master Link Field to include this control,
and its Child Link Field to include the ProductID". I don't understand this
statement.

John Vinson wrote:
>>I have a form that captures a lot of information on actions involving
>>different products. This information is organized in a datasheet subform

>[quoted text clipped - 7 lines]
>>I think the latter option my be more do-able but I don't know how to
>>implement it.

>
>You might want to filter the subform to show only the records for a
>selected product at a time. One way to do this would be to have a
>control - a combo box or listbox perhaps - on the mainform allowing
>the user to select which product they wish to see; set the Subform's
>Master Link Field to include this control, and its Child Link Field to
>include the ProductID.
>
>This would have the advantage of not requiring any code.
>
> John W. Vinson[MVP]



--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200509/1
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Retrieve records, and all records joined to those records, etc., e Peter Stone Microsoft Access Queries 2 12th Jun 2009 05:41 AM
Sorting Sorting Sorting =?Utf-8?B?U2t5ZGl2ZXI=?= Microsoft Excel Misc 4 3rd Jun 2006 02:42 PM
Nslookup query for NS records returns all of the NS records, but not all of the Host records Bob Microsoft Windows 2000 Networking 1 8th Nov 2004 08:03 PM
Nslookup query for NS records returns all of the NS records, but not all of the Host records Bob Microsoft Windows 2000 DNS 2 7th Nov 2004 05:42 AM
Help !!! Sorting records in an Accesss Form with defined butons geo Microsoft Access 2 18th Jan 2004 02:46 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:51 PM.