School Assignment? Project Due Tomorrow? Chat LIVE With A Programming Expert!

Welcome to Dream.In.Code
Become an Expert!

Join 307,221 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,673 people online right now. Registration is fast and FREE... Join Now!




Problem with Ms.Access 2007

 

Problem with Ms.Access 2007

jenson200986

18 Aug, 2009 - 07:28 PM
Post #1

D.I.C Head
**

Joined: 6 May, 2009
Posts: 61

I have two forms. form1 have button to open form2. The way that I want is open with specific. I mean that form1 have Name, sex,... and form2 have Name too and another field. I want to open form2 from form1 with specific name. for example in Name field have sonsonita, tyvanna,... in form1 and I open form1 with tyvanna then I want to input more info in form2 with the Name tyvanna so could anyone help with this problem?

User is offlineProfile CardPM
+Quote Post


jjsaw5

RE: Problem With Ms.Access 2007

18 Aug, 2009 - 07:32 PM
Post #2

I must break you
Group Icon

Joined: 4 Jan, 2008
Posts: 2,664



Thanked: 25 times
Dream Kudos: 125
My Contributions
Have your button on form 1 have an On-Click event to open form 2, then have the text boxes of form to coded with a query that will populate them with information based off of whatever fields you want.

You could put the query for for two in the On Load event.
User is offlineProfile CardPM
+Quote Post

jenson200986

RE: Problem With Ms.Access 2007

19 Aug, 2009 - 01:49 AM
Post #3

D.I.C Head
**

Joined: 6 May, 2009
Posts: 61

Yes, it's on-click. here my code:

docmd.openform "Form2", acNomal , , "Name ='" & Name & "'"

But it open form2 with the blank field. so can you or everyone help with this?
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic

Time is now: 11/21/09 10:42PM

Live Help!

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter Fan Us On Facebook

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month