UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> form to "search" and "display" results in subform then sent to r    
 
   
masterskop
post Dec 9 2006, 12:35 PM
Post #1

New Member
Posts: 6
Hi,

I need help with doing a simple search from a form that I have created. I have a couple of tables, a few queries, and a few forms. As you can guess, I'm quite new to MS Access. I would like to create a form that lets the user to enter a User ID number Then display the results in a subform.

Thanks,

masterskop
Go to the top of the page
 
+
KenSnell
post Dec 9 2006, 01:04 PM
Post #2

UtterAccess VIP
Posts: 1,117
From: Michigan, USA
On a form, put a combo box that displays the User ID values that are available. This combo box will be "unbound" (its control source will be empty). On that same form, put a subform that displays the desired data for each User ID. In the LinkChildFields property of the subform control, put the name of the User ID field that is in the subform's query; in the LinkMasterFields property of the subform, put the name of the combo box that is on the main form. Now the subform and main form are linked.
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 23rd May 2013 - 03:37 PM