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!
  • Students Click Here

*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.

Students Click Here


create 5 new records and enter values on form open

create 5 new records and enter values on form open

create 5 new records and enter values on form open

Hi All

I m looking for a little help with an access DB I m creating, it has a sub form called SubPromotedProducts, on opening the the master form Step2_AssetAssignment, I d like 5 new records to be entered into the subform automatically, as below

this image shows the desired result, so 5 records are created which inputs the following

- "1" to "5" in "No." (record name is NumberCount)
- "promoted Product" in each of the AssetType field
- SponsorshipID is the subform master/child link so would enter the corresponding sponsorshipID from the master form, in this scenario its "7"

I d then like the ability to add any new records to be suppressed, i.e. the user can only populate in the created fields under ProductSKU

I ve had a look about and cant find how to achieve this automatically

Any help would be greatly received!



RE: create 5 new records and enter values on form open

I just saw your question. Have you had any progress to date?

If not, hopefully this'll help:

  1. Add 5 records: Unless there are specific requirements which cannot be handled this way, I'd do so with a query (query object or SQL query) adding 5 records to your underlying table.
  2. "1" to "5" can be handled by having an Autonumber field for your table if that works, but then it'll be 6-10 the 2nd time, and so forth. If you have to have 1 - 5 each time, then it'll take more effort, but there are at least 2 or 3 options to handle that.
  3. "Promoted Product" can be handled within the query
  4. Ability to add new records supressed: that's a form setting you can set from the get go. So this way the query will add your records, and then you won't add anyone to manually add records.
Let us know if this gets you started, and at what point you get stuck if any at all.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

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!

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