Search results

anyone? I would think this would be simple for the more experienced folks here...I'm a noob.

thanks RG.

Hey you're right. So it calculates it but does it store it into the table?

Doesn't seem like the field is being filled out. I changed it from text to number as well. Nothing.

I have 2 time boxes with times in them. How do I get the 3rd textbox to display the difference between those times?

I have a form with a subform. The mainform has 3 combo boxes in which I select the right choices to pull up the right record in the subform. I want to generate a report for that record only. As of now, what I did was use a 'open record' macro. But this preview-prints all the records instead of...

Ah that's what I meant,limit to list. Thanks.

I have a combo box whose row source comes from a table. I want ppl to be able to select from the combo box but I don't want them to be able to make any changes to its content (in the table). How do I do that? I've fiddled around with the Lock features in the forms but I cannot get the right...

Swapping= you mean swapping the order in the original table itself? and the 2nd option, how do u do that?

I have a combo box which I pull values from a table which has 2 columns. When I pull down the menu, both columns show but I want the 2nd column to fill out the field. Not the 1st column (which it is doing by default) How do I fix this? Thanks.

Yea it's the same linkedFields (meaning the name of the fields. Each record has all these 3 fields) Yes, my background is C++. I just need VBA translation :D

rural>>Thanks but I have additional info maybe you can help me with. Instead of pre-set cases ie. "Motor","Home" etc. The combo box I have grows when I add records elsewhere. So it's not pre-set. Let's say there's cbo1 and fieldLinkedTocbo1. What I want is to select from that combo, and have...

rural, any chance this code can be used to open multiple forms based on several cases? I am not opening a form based on a specific combo selection. This is mine: I select a combo, and this is linked to another field (Y/N selection) that is not shown on the form. If this 'other field' is "Y"...

Why does my subform appear in my mainform even without me choosing anything from the mainform combos yet? I have done this 'Choose combo and the subform appears' deal before and usually the subform doesn't appear until I select the combo. But now...the subform's showing, even if the fields in...

In a query, how do I set the criteria to check if it's True or False? (my 'Bad' and 'Good' is actually a Y/N checkbox) I want to open my subform if the checkbox is set to 'True'.

I have 2 combo boxes which I select a 'Year' and an 'Incident'. Based on 'incident', a listbox lists whether it was a 'bad' or 'good' incident. I only want my subform to pull up the record if the listbox says 'bad'. how do I do that?

thanks man, i see it was a question of syntax. I got it working now. :D

If [field1] 'Yes', set [field2] to 'Open'. That's what I'm trying to do. Field 1 is a combo where I choose between 'Yes' or 'No' from an outside table. Field 2 is a textbox that I don't have showing on the form. What code do I put into the 'AfterUpdate' of Field 1 when I change the value to...

btw what is 'd' in the code?

and where does this code go? BTw it shows up in red in the VBA builder.