multiple selections in form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i'm quite rusty with access and can't gat my form to fill in multiple rows of
my table. Does anyone have any suggestions. i'm also not great with basic.
 
Billy,

I'm not sure I understand your question, but if you're asking how to display
more than one record, set the form's DefaultView property to Continuous.
Open the form in design view, and press <F4> to display the form's
properties. DefaultView is on the Format tab.

Sprinks
 
i've designed a form with one multi-select list box which i need to fill in
multiple rows of my table. But the second I enable multi select all field
fill in except my funding stream field.(multi-select)
 
Billy,

Remember we don't know anything about your application. It's always helpful
to post as much information as you can about:

- the generic purpose of your application
- the design of your tables (fields, fieldtypes, and relationships to
related tables)
- the recordsource of all forms and subforms
- what you want to happen when performing specific actions

Please post this information and we can help you.

If you're trying to use a list box with Multi-Select to insert multiple
records, one for each selection, into a table, you will require VBA code to
do so. A way to do this without code is to use a combo box instead, and make
a single selection for each new record.

Sprinks
 
I have a form and three tables:Submission,Funding streams,Line Items,my
funding streams need to have multiple selection on the form which is for
invoice submission pooling funds from multiple streams for a grand total per
invoice. that being said i would like to make one entry into the form and
fill multiple rows of the submission table so it can be tracked. any help on
this is greatly appreciated.
 
Billy,

Analogous to an Order and Order Line Items, there is a natural one-to-many
relationship between an Invoice submission and Funding streams. I suggest a
main form based on Submission with an embedded continuous subform based on a
detail table:

SubmissionDetails
----------------------
SubmissionDetailID AutoNumber (Primary Key)
SubmissionID Integer (Foreign Key to Submissions)
FundingStreamID Integer (Foreign Key to Funding Streams)
Amount Currency
or Percentage Single

Link the subform to the main form by the SubmissionID, i.e., set the subform
control's LinkMasterFields and LinkChildFields properties to the primary key
field in Submissions and the corresponding field in the detail table.

Use a combo box to enter the funding stream.

Hope that helps.
Sprinks
 
that worked but dumps info into submission detail table which is closer to
what i intended thanks
 
Back
Top