Solved

Build one record with multiple forms

Posted on 2007-04-04
6
235 Views
Last Modified: 2012-05-05
I want to create multiple forms that will gather information and store it in one record. i.e. Step 1 (what size?) Step 2 (what color?) Step 3 (What is it?)

Each step is it's own form that add information to the same record.
0
Comment
Question by:zero118
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 125 total points
ID: 18851252
How about a single form, bound... Just make the appropriate steps visible at the right time:
ie start with just txt1 visible.
 
In txt1's after update event:

If nz(Me.txt1,"") <> "" Then
   me.txt1.visible = false
   me.txt2.visible = true
end if

In txt2's after update event:

If nz(Me.txt2,"") <> "" Then
   me.txt2.visible = false
   me.txt3.visible = true
end if

etc....
0
 
LVL 1

Author Comment

by:zero118
ID: 18851277
I know how to create a single form, I Require multiple forms to build a product as it goes.  Like if it's left or right, the rest of the options on the remaining forms would need to be taylored to that.
0
 
LVL 61

Expert Comment

by:mbizup
ID: 18851314
Buid your forms and bind them to the table.  To filter them to the correct record on opening:

DoCmd.openform "frmYourFormName",,,"ID = " & me.ID

This is assuming that you are launching the forms from some "main form" bound to the table.  You need something like this to let the other forms know what record you are working with.
0
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
LVL 1

Author Comment

by:zero118
ID: 18851986
Actually, I think your first suggestion will work just fine inside of Tabs =-)  Thanks.
0
 
LVL 61

Expert Comment

by:mbizup
ID: 18851997
Glad to help, but why the "B" grade?
0
 
LVL 1

Author Comment

by:zero118
ID: 18852448
:)  Not everyone can score an A for everything.  It wasn't EXACTLY what I was looking for but turned out to work okay.  ;-)
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question