Form To Enter Data on Multiple Records?

[shelby55]

Hi

I'm using Access 2010. I have a database of patient transfers where one transfer is one record. The hospital uses private transport companies (including taxis) and receive invoices monthly. Vendor is one of the fields in the record table and I would like to be able to have a form where the user selects on the vendor or date or whatever field and gets a list of records. From there they can check a box for all that apply and when they type in the invoice # in the form it is applied to all that were ticked...is this possible?

Thanks.

 

[TheAceMan1]

Howdy shelby55 . . .

Bear in mind that we don't know your thought processes nor can we see what you invision in your mind, the screen, or the db for that matter. This means to us that your opening statements are not sufficient to paint a good picture. When you say ...

[blue] ... I would like to be able to have a form where the user selects on the vendor or date or whatever field [purple]and gets a list of records.[/purple][/blue]

Get a list of records from [blue]where?[/blue]
Have you no [blue]rules[/blue] for what will be returned by the selection?
Any [blue]relationships[/blue] going on here?
ect ... ect ...

Perhaps you can provide some sample data to enlighten this thread?

[blue]Your Thoughts? . . .[/blue]

See Ya . . .

Be sure to see FAQ219-2884 Worthy Reading!
Also FAQ181-2886 Worthy Reading!

 

[shelby55]

Hi

The physical process is that an invoice is received from a taxi vendor that identifies each transfer and the amount. The hospital will then validate those charges to this database and I want to be able to enter the invoice number and date received to each of the applicable transfers in the database en masse, not going into each record to enter it separately.

I envision that the form has 4 search criteria on it and the user can enter some, all or none then hit the search button. The records resulting are from the transfers table and will be based on search criteria. Most likely for this purpose the search criteria will be taxi vendor.

Based on the list showing up from the search, I would like to be able to tick the ones appropriate to the invoice and when I enter an invoice # on the form it will be updated to all the records that were ticked.

Does that explain it better? Thanks.

 

[TheAceMan1]

shelby55 . . .

Just what are the key fieldnames you'll be using and their data types? Also what are the table names?

See Ya . . .

Be sure to see FAQ219-2884 Worthy Reading!
Also FAQ181-2886 Worthy Reading!

 

[SkipVought]

Provide general information.

Receive general help.

Provide specific information.

Receive specific help.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}