Search results

My code compiles but I cannot change any control using this method. It works fine if I type it in but try to change it with VBA and it chokes. Any ideas?

sUser is defined elsewhere using the code you mentioned. Thanks for your help anyway. Any ideas on why it won't allow me to assign a value to the control?

This opens the form: Private Sub cmdOpenF_BudgetItems_Click() On Error GoTo Err_cmdOpenF_BudgetItems_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "F_Budget_Items" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_cmdOpenF_BudgetItems_Click: Exit...

Yes. I tried updating at the query level and it let me add the info. I also tried the Before_Update and it prevented the form from opening, telling me that the OpenForm action had been cancelled (the form is launched from a command button on another form).

I went ahead and moved the code to the Form_Open event and am still getting the same error. That really is the key question. Why won't it let me assign the control a value??

What I'm wanting to do is if the user makes any changes to the data in the form, his username gets tagged to the record. Would that effect being able to assign the value?

I have been pulling my hair out (OK, I would be if I had enough to do so) over trying to assign a value to a control on a form. Basically, when a change is made to the form, I'm using the AfterUpdate event to trigger the code. The code in the event is Me.txtWho = Environ("UserName") Simple...

Thanks Bob. That did the trick. You da man! :D

OK. I have searched and searched and every thread dances around similar situations but none seem to address this particular one. I am trying to make a control on a sub form visible/not visible depending on the condition of a control on a main form. The catch is that the control I'm trying to...

Robert, That link doesn't seem to work.

I'm having a real time finding a way to import a dbf flat file into a table. It's effectively a spreadsheet but I can't use TransferSpreadsheet because it doesn't recognize the file type but when I use TransferDatabase, I don't know what table name (from) to use. I've tried it using the...

I don't know if this has any bearing on things but it might illuminate the problem. The criteria information for the underlying query is selected with text boxes (pop-up calendar driven) and combo boxes in the form header. The records are updated through a command button that simply requeries...

Pat, Checked the Z order and the text box is definitely on top. The thing that doesn't make sense is when you click on either a combo arrow (the box portion is obviously hidden) or the overlaying text box OTHER THAN THE FIRST ONE, ALL the combo boxes disappear. Any ideas?

I'm fairly certain it is but how do you check the Z order?

Right. And that's what I did but I still have the disappearing combo boxes????

Just to clarify something here. When I say that the combo box disappears, I mean literally, the whole control disappears, not just the data. With the next design, the text boxes remain and the arrows (the part of the combo that is seen) all disappear! :confused:

OK. Did as you said in your example database/posting and once again, it works fine for the first record only. Try to click on any of the other combos in the continuous form and they all disappear. Any ideas on what I might have missed?

Thanks Pat. Once again you come to the rescue. I'll give it a go and see if I can get it to work.

I have a continous form that once the combo box filters are selected, shows the applicable records. Included in records, I've put a bound combo box that allows the user to fill in that particular field. This works with the first record but when you attempt to select the other records, all the...

That was it. Thanks FOFA!