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.


Form and sub-form that allows users to split a line item.

Form and sub-form that allows users to split a line item.

am working on a form and sub-form that allows users to split a line item so partial shipments can be recorded. If my text box for entering a partial amount to be split out is bound to a data source I cannot make an entry. If the text box is not bound and I make an entry, the number will appear on my sub-form for all the line items. Only one line item is processed when I click on the button for splitting the entries, but this makes the form and sub-form more awkward to use. Any thoughts?

RE: Form and sub-form that allows users to split a line item.

It is difficult to understand what you are trying to do. When you say "split a line item" what does that mean in data terms? Are you creating a new record? Can you describe the recordsource of the main form and the subform. An example would help.

RE: Form and sub-form that allows users to split a line item.

I am creating a new record. The data source for the sub-form, the one where a record is "split", uses a query as its data source. The query consists of two tables connected by a left join. The data source for the main table is also a query with two table connected by an inner join. The tables in the query for the sub-form are called ORDERS and ShipPartial. The ones in the query for the main form are ORDERS and CUSTOMERS.

RE: Form and sub-form that allows users to split a line item.

If you need to create a new record based on some information from an existing record then you would do an append query. But you need to explain better what needs to be created. What table are you inserting a record to and what values are inserting and where are the values coming from. My guess you would create a procedure where you do an insert query and pass to that procedure the OrderID and Quantity based on values from the form.

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