INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • 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!

*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

Populate a form with alternating data from a separate table

Populate a form with alternating data from a separate table

(OP)
Hello Everyone: I have a form to enter data into a table. I want alternate new records to populate the form with an alternate name...either A or B. I assume the A and B will have to be in a new table. Example:

New Record
Populate A into field

Next Record
Populate B into field

Next Record
Populate A into field

Next Record
Populate B into field

I am stumped as to how to go about this. Any advise would be appreciated.

Sophia

RE: Populate a form with alternating data from a separate table

  • Are all of the records new?
  • Are these done in a batch or one at a time?
  • Is there any field or fields that determine the order/sequence of the records?
  • Do you have a table with A and B in a field?

Duane
Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016

RE: Populate a form with alternating data from a separate table

(OP)
Hi Duane:

Thanks for the reply.

•Are all of the records new? Yes
•Are these done in a batch or one at a time? One at a time.
Is there any field or fields that determine the order/sequence of the records? No. We just want to alternate the employee who looks after the record. The employees are A and B, in my example.
•Do you have a table with A and B in a field? I don't yet, but thought that this would be the best way, since the A can be changed to B later and vice vers.

What I am trying to do is to assign an employee, either A or B, to a case.

Sophia

RE: Populate a form with alternating data from a separate table

"Is there any field or fields that determine the order/sequence of the records? No."
Do you have a PK field in your table, like an AutoNumber? That could be used as "order/sequence" of the records.

Have fun.

---- Andy

There is a great need for a sarcasm font.

RE: Populate a form with alternating data from a separate table

(OP)
Hi Andy: That's a good idea, since there is a PK in the table. But how would I go about using it?

Sophia

RE: Populate a form with alternating data from a separate table

Dophia,
What Andy and I are attempting to promote is a field or fields that can be used to determine the most recent record so the most recent employee can be determined. How do we know if A or B was the most recent if there isn't a stored value that provides this information?

Duane
Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016

RE: Populate a form with alternating data from a separate table

You can check to whom the last record was assigned, and assign the new record to another employee. So if Max(PK) from your table was assigned to A, new record will be assigned to B, and vice-versa (or versa-vice smile )

Have fun.

---- Andy

There is a great need for a sarcasm font.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

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!

Resources

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