Search results

This should be really simple, but I am stumbling on the criteria. I have a combo box which returns "Y" or "N". I'm using this value as criteria for a field called [Planned=Y/N]. This field stores either a "Y" or a "N" to indicate that a network outage was planned or not. If the combo box is...

Shouldn't you be able to do this by just assigning the "print report" option to an inserted button? You can then select the name of the subform in question and you have a quick and easy button that will print the output.

Egg...on...face. No, I had adjusted it to 1 to only show the first field in the drop down. I assume that there is a better way to adjust the list width. :rolleyes: Thanks again man...you have solved my delima and shown me more.

A dialog box pops up that says: Tape Value should be []

Well, I added the leading "Me." but this did not correct the issue. If I change the VBA to read: Private Sub cboTapeUsed_AfterUpdate() Me.txtTapecost = Me.cboTapeUsed.Column(1) Me.txtTapevalue = Me.cboTapeUsed.Column(1) End Sub ...then I do get updates in the text box. This tells me that...

Thanks again RuralGuy. You are the best! I'll try it out.

Can you update multiple text boxes simultaneously? I have a combo that needs to update two text boxes. The first is working correctly but the second is not. Here is the code I am using: Private Sub cboTapeUsed_AfterUpdate() Me.txtTapecost = cboTapeUsed.Column(1) Me.txtTapevalue =...

Here is my problem. We stage outages once 3 tickets have been recieved for the same problem type, but only if all three tickets are entered within 16.65 hours or 999 minutes. I.E. the third ticket is received within 999 minutes of the first ticket. How can I capture this based on the field...

Yes Jon! Thanks. Your gift keeps on giving...:D

Does it matter if the control name and the source name is the same? In this example I have a textbox with the name [Tape Cost] and it's source field is also called "Tape Cost".

Double-post.

Yes. I am counting from 0. A little baffling. I'm going to try rebuild these controls and start from scratch. Something is preventing this from updating.

Thanks RuralGuy! I will be sure that I avoid spaces. I did update the code as you suggested and the error does not appear. The text box is not updating however. Is there additional VBA I need to add to perform a refresh for that control or something similar?

I'm trying to have the user select an item from a combo box which gets its values from a table with multiple columns. Once something is selected in the combo box the form will auto-update the adjacent text box to a value in the same row (different column). The combo box is called 'Media' and...