	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

Access 2007 - Pass data from form01 to form02?

Asked by Naomh in Infopath, Access Forms, Access Coding/Macros

Tags: Microsoft Access 2007

Hi Experts,
I have two forms and I would like to pass a value in a text field (SongNo) on form01 to form02 using a button. I'd like form02 to apply the value it recieved from form01 and apply it to the where clause of the query form02 uses (Select lyrics from tbl_Lyrics where SongNo = [value from form01]. Is this possible in Access 2007? I'm able to pass a hard coded value from form01 to a text box on form02 but i've been unsuccessful in finding a way to have the value effect the where clause of the query for form02.

Thanks for any help,
Kyle

View the Solution FREE for 30 Days

20100204-EE-VQP-115 - Hierarchy / EE_QW_3_20080625

Hall of Fame

1. clayfox57,836
2. mccarthy...6,000
2. bank_on...6,000
4. zephyr_hex4,750
5. quihong4,375
6. StevenMul...4,200
7. Haewood4,000
8. whoajack3,000
9. kiranvj2,800
9. dp_expert2,800
11. robberbaron2,500
11. sharepoin...2,500
13. liebrand2,000
13. GrahamSkan2,000
13. QPR2,000
13. puppydog...2,000
13. AshleyBr...2,000
13. Greeny212,000
13. Oestonee2,000
13. rmicone2,000
13. MelMc2,000
13. techExtreme2,000
13. pcelba2,000
13. Joestetz2,000
13. janicet1232,000
13. RameshS2,000
13. mo1one2,000
13. Deepandp2,000

1. clayfox467,302
2. Robbie_L...81,850
3. MelMc26,089
4. tedbilly21,800
5. ramuar1...18,328
6. GreatGerm16,000
7. zephyr_hex15,550
8. Dhope14,500
9. Stevenmu11,000
9. 6686611,000
11. andrei_te...10,500
12. MsShadow9,768
13. puppydog...9,500
14. CloudedT...8,400
15. mccarthy...8,000
16. NBSO_ISS7,900
17. Mountaine...7,700
18. melli1117,250
19. thman6,460
20. StevenMul...6,200
21. hstaples536,075
22. bank_on...6,000
23. mo1one5,500
24. Oestonee5,300
25. Poolio5,000