Smart questions
Smart answers
Smart people
Join Tek-Tips Forums

Member Login

Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Enter data into the same record using different forms

assiri (TechnicalUser) (OP)
31 Aug 08 8:55

--I have two forms named "Form1" and "Form2" and a Table named "Table1"

--Table1 has the following fields

--When a user enter data into "form1" that data stores in the "field2" and "field3"("field1 is an autonumber field")

-Using a "Next>>" button user goes to "form2" and enter data.I need to enter data into the "field3" of the previous record.(The record user entered data in form1)

Could u please give some code or information regarding this.

fneily (Instructor)
31 Aug 08 15:18
You sure you are explaining this correctly? You have two forms based on the same table. A user enters data for field1 and field3 in form1. They then move to form2 and REenters data for field3.
Is this right, or am I confused? The obvious question is why would a user enter data twice to the same field3?
Please restate clearer.
missinglinq (Programmer)
31 Aug 08 15:42

And even if he meant to enter data into Field4, why use two forms to enter data into four fields in one table?

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

assiri (TechnicalUser) (OP)
31 Aug 08 18:31

You are correct,

-I have two forms based on the same table.

-A user enters data for "FIELD2" and "FIELD3" in form1

-Then move into form2 and enter data for "FIELD4"

-Though there are two forms user enter data into the same record

-I have used two forms because,in form1 I have two list boxes and in form2 I have a set of checkBoxes.I have not enough room in the form1 to occupy these three items in a user friendly manner.

fneily (Instructor)
31 Aug 08 19:01
Look at the Tab Control. In the Help pane, do a search on Tab Control. There you will find an explanation and how to create one. That way all your controls will be accessible on one form instead of two.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close