By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,223 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

Loading searched data in a form

P: 19
Hi guys, am new in developing with Ms Access

I use Access 2003. I've got a search screen which is working perfectly fine. now i wanna load the data that's = to the search criteria but i want it in another (seperate) screen

Can u please kindly help as to how can i do that

1st screen (Search screen) contains 3 textboxes (customername, customersnumber and repname) which i search by

2screen (where i wanna load the data) i want it to contain everything it get regarding that search criteria. Please let me know if there r any Qs

Thanks
Noks
Mar 2 '07 #1
Share this Question
Share on Google+
4 Replies


Rabbit
Expert Mod 10K+
P: 12,315
You could set the control source of the text box on the second form to reference the first form.
Expand|Select|Wrap|Line Numbers
  1. =[Forms]![First Form]![Textbox Name]
Mar 2 '07 #2

P: 19
k i get dis. but am tryin to load the form with data that is not on the previous screen which i selected from ma original query. How do i go about loading that 1?
Mar 5 '07 #3

P: 19
Thanks 4 yo response rabbit.
It's workin fine now. I used d ff. code

On Error GoTo Err_cmdGo_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Form name"
stLinkCriteria = "field name =" & Me![textbox name]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_cmdGo_Click:
Exit Sub

Err_cmdGo_Click:
MsgBox Err.Description
Resume Exit_cmdGo_Click
Mar 5 '07 #4

Rabbit
Expert Mod 10K+
P: 12,315
Glad you got it working.
Mar 5 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.