Search results

Someone figured out my problem. I needed to have the field names on the form spelled different than the control source qry names.

I have 2 text fields on my form named SOLDTONAME AND SHIPTONAME. Many times they are the same spelling of a customers name. To eliminate clutter from my input screen, i want to make an IIF statement. If the 2 names are spelled exactly the same, then make the ShiptoName form field empty...

i have the combo box made. how do i make it "unbound"? On the row called "Bound Column" in the guts of the combobox, there is a "1". what do i do? thanks

Is it possible to create on my form a drop down combo box for just viewing purposes of table values? i want to manually enter my value but sometimes i like to look at my Standard ranges as a double check. I do NOT want the combo box values to come into the field. is there a way to do this...

Pat - i am sure that you are right about perfect linkage. i just thought of something that i left out. i hope that i can explain this. or i can send a file if you like (tell me how). in my subform sfrmdetail. it is based on a qryFormulaDetail which uses parts of 2 tables: In this qry, i...

I changed it to a Requery Button with me.requery inside the buttons ON Click event procedure. the refresh seemed to work too but from what i read, and what Pat said, i guess requery is the proper one. but if you have ideas on how to imbed such a requery into the PlantID and yet allow the...

anyway, i took out the requery in PlantID. temporarily, i just made a command button on the mainform. i used me.refresh inside the button's ON CLICK event procedure. it works fine. Until we can fix the issue. Which should i have used? refresh or requery? i am confused on this part. this...

Pat - another illustration of how the necessary Requery is badly affecting my input mode. let's say i am inputting a new record and i have the Requery in plantId. i do the 1st 2 fields and then put in a PlantID of say 4008. before i hit tab or enter, i suddenly realize that this record should...

Hi Pat - Here is what i have for your review. in my subform named sfrmFormulaDetail that is inside the mainform named frmJunction: name: sfrmFormulaDetail source object: sfrmFormulaDetail link child fields: formulaID;PlantID link master fields: FormulaID;PlantID in my mainform called...

fyi - here are 5 methods that i unsucessfully tried so far. penwood =================================== Private Sub cboPlantID_AfterUpdate() 'method 1 did not work - Me.Refresh 'method 2 did not work - Me![sfrmFormulaDetail].Form![PlantID].Requery 'method 3 did not work -...

I have a mainform with 4 fields which are marked with 4 primary keys: soldtoId, shiptoID, PlantId and formulaID. PlantID is a long integer number field and the other 3 are text fields. there is no default values. I have a subform1 that is linked by PlantID and FormulaID. These 2 field names...