Search results

here's my code Here's a bit of my function. It takes a selected line order from another form and based on that, displays the L, S, F & M values a certain way. Theses values are changed thru the combobox selection in the main form. The display textbox calls this function below. I don't see...

I have a few combo boxes in which the user makes selections and thoses values are taken and displayed in textbox for viewing. But when there are no values selected in the combo boxes, my fcn for the display goes weird and says invald use of null. I tried If Isnull (L) then...

Mytextbox=Mycombobox.column(1) i put in load, current, onchange. I don't really know which i should be using, what isn't necessary, i just tried to cover all the bases.

i have a textbox that displays values from a selection made in a combobox. does it matter if i just put the code in "on load" and not in the "beforeupdate"?

it still doesn't update. Does it have to do with the values combo (A) is based on? Ahh! things never seem to work for me!

now i know other people had this problem with the mouse scroll cycling thru the records. I changed the cycle property to current record, but it still scrolls through my records, which i don't want. what happened?

I have a combo box(A) in a form that gets values from itself--from values entered in a text box and another combobox(B). When I change the values in the text box the values update in combo(A), but when i change the selection in combo(B) the values are not updated in combo(A) until i close the...

I have a subform showing a continuous list of records. I want to create a button that links to another table, but is only enabled when there is a numeric value in one of the subform's fields. Now if I put this button in the subform it works great, but when I do the same thing in the main form...

I have a form with a subform showing continuous records. I want to create a button in the main form so that when i press it will go to creating a new record.

I *think* I might have seen this question come up, but haven trouble finding it. How do I prevent the scroll bar from scrolling through the records? I want the user to view only the one record (filtered) and not accidentally scroll to the next one.

Ok, I figured it out. Actually it was my fault (mistyped). Now my problem is my subform has continuous forms and the button only gets enabled/disabled(depending on the value for the first record in the subform) when the main form initially opens. If I select a different record in the subform...

I have a button in the main form which I want enabled/disabled depending on if there is a numeric value in one of the text boxes in the subform. I can get this to work if the button is in the subform but not if it's in the main form. It says object doesn't support this property or method. How...

oh...I'm sorry, would you be able to tell me how to do that? I'm pretty new to access.

Ok, I figured out how to have my form update according to changes in another form, only problem is it only works on one record. Is there a way to have it run thru each record an update each?

Is it possible to have the user select a sort by (say in the form) and have the report sort by this instead of presetting it in design view?

I have a form (frmA)that displays the set of records continuously. When this form opens there is a field that bases it's display on values chosen in another form (frmB) that's open. I have two problems. First, when frmA opens the displaying field is effected only on the record that has focus...