Search results

I hope this isn't a double post. Thanks again RG, I have one other quetion. What is the quick and dirty explanation between the On Open event and the On Load?

The properties of the opening form are set the following way but it continues to open in single form view. I need it to open in datasheet view. If I open the as a stand alone it opens in Datasheet View. Can someone point out my error? Property set as: Popup Yes, Modal Yes Default View Datasheet...

Thanks RG, It works your way.

Thanks RG for responding. I looked up the acdialog in help and tried the following code but it in this format when it gets to the docmd.open it opens a window to select a macro. So I tried putting quotes around the name and it tells me I have no form with this name. As I copied pasted the name...

I have a form that opens another form and sets the first form visable property to false. When I am done with the second form I would like to get the first one visible again. Right now it doesn't come back. If I make an open form docmd on the close of the second one much of the data has to be...

I am trying to populate two of many controls on my form from the lookup results of an unboud combobox rowsource. I have tried different things that don't work because I think I need to use the after update of the combo box but I can't seem to find how to get to the different columns in the...

Thanks Tiro worked like a charm

Thanks for responding Curtis: I have an Order Header table with customer information and an Order Line table. I would like to beable to basically create and invoice (form) that would add the order and customer information to the Order Header table and add lines of product on the form which...

Is it possible to use one form to add records to two different tables that have a linked field? Or do I have to make two different forms? I have an Assigned Order table and Assigned Order Lines table with the order number as a common field. These tables are updated the previous end of...

I have a form updating table information with route and delivery information. From a combobox with the RowSource as the Order Number field in the table. The user is able to key in an order number, as he has it in hand, or select it from the from the list. The problem is, if the user keys in...

the value of PegRoute is entered by the user. I believe you have solved my problem with your earlier input. I just had to walk away for a while and come back. I thought I had set up a requery on the combobox to eliminate orders already assigned and instead I requeried the form. This dropped all...

PegRoute is an unbound textbox. I am trying to get the bound text box RouteID to always be the same as PegRoute.

No, the the record source is the table.

Thanks for your help RG, When I apply this code I get a runtime error "Update or Cancel without AddNew or Edit" when I try to select an order from the combo box. It debugs at RouteID = PegRoute Private Sub Combo44_AfterUpdate() Dim rs As DAO.Recordset ' Find the record that matches the...

Yes OEOO_ORDR is numeric. I don't understand the DAO or ADO question. I don't believe I am using Active X here so maybe I'm using DAO.

My object here is to find a record in a table then update two fields in the tabl, e RouteID and Seqence number. I need the RouteID to retain the value of PegRoute until the value of PegRoute changes. I thought I had this worked out before with the help of this forum but when I put it out to the...

I think that is the problem. What I have done is went about docmd.close on the calling form and docmd.openform on the popup close event. Isn't as slick as I woud like but it works. Thanks for all your help. I am on to other problems of my own making.

I can't get it to work for me. I will have to try another way around the problem. Thanks for your suggestions.

It opened the same way so I took a look at that on load event and I had a function to minimize the switchboard form. So I dumped that and what happens now is the code still doesn't pause as the first form comes right back out front. MS help said the popup had to be modal; I tried that, but...

Thanks for responding. Thats the way I had it first, but what happens is the new form comes up minized with no restore buttons just close and the original form comes right back. I plugged in maximize but the orginal form keeps coming back.