Hello all,
I have a database that tracks mileage and fuel for our fleet of trucks. We have a paper trip report that gets entered into an access database.
On the form "frm_TripReports" there is an "OdometerStart" and an "OdometerEnd". Each trip report is specific to each Vehicle. Vehicle is...
That worked great to bring up the proper vendor but it autofilled the rest of the form with the last record. Is there a way to have it open to a new record while diplaying the VendorNo?
I have a form called "frm_Vendors" that lets you select a vendor from a combobox and then displays the vendors details. I would like to open another form called "frm_NewPurchase" that opens to a new record, but autofills the "VendorNo" text box with the "VendorID" from the previous form. Can...
Figured it out. May be a bit sloppy but I put this code into the forms Resize event.
Dim intID As Integer
Dim rs As Object
intID = Me.VendorID
Me.FilterOn = False
Set rs = Me.RecordsetClone
With rs
.FindFirst "[VendorID]=" & intID
Me.Bookmark = .Bookmark
End With
rs.Close
Removed the filter...
Hello all. I have a form called "EditVendor" that allows you to edit a vendors details and I have a button called "SaveAndClose" that closes the form and opens up another form and goes to the same record. Heres the code (I know my names are sloppy):
DoCmd.OpenForm "frm_Vendors", , ...
So if I wanted to auto populate multiple fields, the correct way of going about it is by having separate tables for each field? Like a table for just company names, and another for departments and so forth?