Recent content by VaughnIT

I'm trying to create a form with a combobox that will show a list of Projects and will automatically populate, Customer number,PO number, company name, address, contact. Those fields are all entered in a form name Orders and are stored in the Orders table. I've created a combobox in my new form...

I have a form that contains a subform. In the subform I would like to calculate the field Subtotal and Total. The subform contains: NumPatients, LabelsPerPatient, Samples Therefore Subtotal = NumPatients * LabelsPerPatient and Total = SubTotal + Samples How do I get these fields to be...

I had a table with 13 records and manually deleted the 10th record from the table. The first field PersID is of type Autonumber. How can I get that be reordered so the PersIDs are numbered from 1 to 12 consecutively rather than having PersID 10 missing. I need this because right now the database...

I had a table with 13 records and manually deleted the 10th record from the table. The first field PersID is of type Autonumber. How can I get that be reordered so the PersIDs are numbered from 1 to 12 consecutively rather than having PersID 10 missing. I need this because right now the database...

I have a form with a combobox (Candidates) and want to be able to add a new name if not on the list . How can I have the form to enter new Candidate be invoked once I type in a name in the combobox. I need to invoke the form because inserting the name directly in the Candidate table would be...

I have a form (PaymentInfo) to enter different payment info. How can I create a screen to display multiple records at a time. I'd like to have the user be able to select a record and when that record is cliked on then the PaymentInfo will be displayed to make corrections to that record.