Search results

i'm on '97 --- actually, the case thing is what i'm thinking. or some "if" logic (a really really long if statement) for all possibilities of tabon. i'll send the db to yr yahoo

oh snakes! i get some error when i try to open your example. unrecognized database format. i do not have such a control. i just have record selectors that scroll through the records of the mainform. this subform is linked to the main through a field called TabOn. there's a half-a$$...

IF you want to use VB... ignore this ~~~~ i'm a VB newbie. also, i'm not sure if you want the results displayed on the same form as bowlers ID ... if so, disregard this suggestion. You need one form with a combo box of bowlerIDs and another form with bowlerInfo that will open based on which...

i thought you told me that i was adding the code to the form not the subform properties

Can someone please help. I am trying to hide a column in a subform... the following is the suggestion I've rec'd. but can't get it to work. :confused: Private Sub COMBO_change() Me.sfrm_CToolInfo.Form.CuttingDiameterNominal.ColumnHidden = True End Sub

thanks for all your help, Pat - I will give it a try. But i think i might run into trouble because the dimensions are associated with each tool number on the drawing. The drawing name is called a Tab-on, which is only the name of one of the tools on the drawing. So I have a relationship set up...

hmm, this is hard to explain... i have a book of tool drawings. Each drawing contains a picture and a spreadsheet of dimensions. Each drawing can refer to any number of similar tools having the same geometry. From drawing to drawing, the dimensional callouts (or titles) can be different but...

but don't I have to "dim" some variables first? and does it matter if this is not a combo box?

unfortunately, I know just enough to get frustrated. Where do I type this in? The properties of the subform does not have a columnhidden property.

I have a form with several subforms. In one of the subforms, the data is a result from a query (a select query built from two tables). This resulting query has many columns (more than 20 and growing by the day). Some of which don't always contain data for a recordset. On the main form as I...