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


combox and subform search form

combox and subform search form

combox and subform search form


I have a search form. The search form has a combobox and a subform. When a user selects from the combobox (they select a supplier code), the subform will display the the searched results.

In the subform, users are allow to add new records. When the user add a new record, the supplier code (that was selected from the combobox) will automatically input the same code into the new record.

How can I stop this from happening? the user can add a new record but the supplier code does not have to be the same as the combobox selection.

any help or suggestion is very much appreciated!

RE: combox and subform search form

I am assuming you used an unbound combobox and a subform linked to the value in the combobox. If that is so then the subform will automatically populate new records. No way to stop that, you would have to modify what you are doing. The only way to change this would be not to link the subform the the combobox. You then have to write code on the after update event of the combobox to do your search. You can modify the query of the subform to do the filtering or use the filter method of the subform and apply a filter.

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