Recent content by Azie

I am using the wizard version of Find Record on a Command Button. It opens the screen and allows it to find a record. But the screen does not close. I am not stuck or all that happy with the wizard created screen on the Find Record button if there is another way. I just need it to find a...

I have a form that is in veiw only I need to make edit or view. The record source is a query (is this the problem, if so I need away around it). I am trying to find an existing file to view or edit. The form will only allow views. I am trying to use the DataMode:=acFormEdit code. I either am...

Thanks for the advise, I did find what you meant. I get an error message.....You cannot find or replace now. When the Invoice Prints it seems to do a save and put the form (screen) in add mode. Thanks Again...it sounded like it should work.

I am printing an estimate off a form and then I would like to go back to the screen and print an invoice ...without typing in all the data again. The estimate has a distinct number and will also be the invoice number. Any suggestions would be helpful. I was looking for something like a...

I have a form called Daily Revenues, in that form a field called Invoice #. I need to print out two copies. I need it to prinnt only on the current record on the form. I am using a command button on the form. The following is the code I have set up through the code building [Event] on the...

I have a combo box (Vehicles), and I want to filter on the criteria CustomerID to only show the vehicles for that particular CustomerID

I am wanting the tab automatically from the last field in the Main Page to the First Field in the Sub-Form.

I added a newly created (tested) form to the Switchboard. It seems it has lost its direction to the Table it was created from according to the error message. Is there a way to fix it. Even when I edit the form now it shows the table in properties. But even if I run the screen as a stand...

I am wanting to start a field that is auto number and a key field named invoice# at a number close to the current invoice number. Is there a way to start the number at a different number than 1, I would like to start in a like 3000-4000 range.

I have an option group that delivers option values (1,2,3,4). I have set values in a table in dollar amounts to correlate with the option values (1,2,3,4). How do I set this up to show in a form as dollar amount.