Search results

Ok Bob, I'll give it a try and will report back. Thanks.

I mean, one more textbox, say tbo2.

Hi Bob, Thanks for stopping by, In frmCars there is tbo1, which is unbound. In tbo1 I want a value to get assigned according to which button was previously pressed (in another form) in order to open frmCars. My goal is, then, to have another tbo in frmCars, say tbo2, to check: if...

Ok, the code is: Forms!frmCar!tboDetail = "Tyre" Thanks.

This is where I came up so far....: Private Sub Tyre_Click() DoCmd.OpenForm "frmCars" End Sub What I don't know is how to syntax the following expression: When frmCars opens, find tboDetail and assign to it the value "Tyre" Thanks.

Hi Bob, I posted this: http://www.access-programmers.co.uk/forums/showthread.php?t=265985 Could you possibly check? It must be simple.

Hi, I have a form, with just two buttons, say "Tyre" and "Engine". These buttons open the same form, say frmCar. What I want to do is when I click the "Tyre" button, a tbo in the frmCar to get as value "Tyre" and when I click the "Engine" button, the same tbo in the frmCar to get the value...

Thanks for everything. Especially, for the motivation to keep it up. Really! I was very lucky to find you around. -George.

I built a query from tblDocEgk. Criterion for TypeID: [Forms]![frmtblType]![TypeID] (TypeID is there, remember?) Criterion for "Aregk": [Forms]![frmtblType]![cboEgk] (cboEgk value is also there, just selected) Then, on AfterUpdate event of the cboEgk, I just wrote: Me.lstAnalysis.RowSource =...

Did it Bob...

1. Yes, it's a hidden textbox. Form's Record Source is qryAllBase. TypeID is part of this query. 2. Yes, it's the same. I don't know though if this makes things worse, but a TypeID may have many "Aregks" and one "Aregk" may refer to many TypeIDs. It's a Books & Authors analogy.... (sorry)...

It is correct. Listbox RowSource property: Nothing (will explain in a moment) Cbo RowSource property: SELECT tblDocEgk.Aregk, tblDocEgk.TypeID FROM tblDocEgk WHERE (((tblDocEgk.Aregk) Is Not Null)) AND tblDocEgk.TypeID=qryAllBase.TypeID ORDER BY tblDocEgk.Aregk; Cbo bound column: =1 Cbo...

Thanks Bob. Well, I returned back to previous saves, before our conversation here, and still, the problem was there. Actually, I never changed the criteria in the cbo's SQL. I chose to stick to mine instead of referring to Forms!.... because, if you remember, the record source is already there...

Feelings when programming can vary, I'm afraid, with the speed of light. If you don't want to follow any more, I'll understand (it's like being nominated with the wrong Oscar....;-). Also, I'm dropping the "Cars" simplification naming and using real case names. Anyway, it seems the cbo does not...

Well, well, well... And the Oscar goes to.............. Before the nomination(!!), let me tell you what I did: Your idea of assigning the result of the SQL statement to a query was excellent. BUT, the statement you provided that referred to the loaded form (Forms!frm1, etc...), returned a...

I cannot save in an earlier version because db uses features that require the current file format. Problem is that I've deleted almost everything. Can't imagine what's left that prohibits the conversion, really, no fancy things used, in the first place.

Same applies here, as well! Thanks a lot for all this help, I'll try to save to mdb and report back.

Can't save to mdb, got a warning message about some restrictions. Also, database is over 2mb (it's 4). Can I upload it somewhere else and send the link (given that you can read accdb files?)

Yes, CarID is numeric. I used your numeric code. Still, I get the same runtime error. Access can't find the input table or query...

Bob thank you very much for your time. You probably missed this one too. Never mind, I'm pasting again a previous post of mine explaining this point: