Recent content by hrabbit

Hi again gurus, I am hoping someone can help me set a default value in my drop down box to the first value that my recordset row source sql query returns. Right now I have to click on the box and select the first record in the list because the default is blank. Is there any way to do this...

Thanks so much for your suggestion. I've tried using it all different ways and it just won't work. No matter what I try it will not concatenate anything with a query. The message I get is: "Runtime error 3078 The microsoft Jet database engine cannot find the input table or query...

The query itself is "Select [cadb_PSRM Pred].[psr_scdn], [cadb_PSRM Pred].[psr_name FROM [cadb_SBR Set] INNER JOIN [cadb_PSRM Pred] ON [cadb_SBR Set].[sbr_name]=[cadb_PSRM Pred].[psr_scdn]" This is a way shortened version. That query is called qryPredsNoDup and works for form A. For form B...

Hi all, I have two forms that use the same subform. The datasource for the subform needs to be different for each of the two forms, so I set it in an on_current event private sub in each form. It works but is this the best practice? Also, the datasource for one of the forms is a query, while...

I'm new to Access programming (could you tell?) so I'll be competing for the champion dunce position. I greatly appreciate the help and the clear answers. Rebecca

Hi All, I know this is a very basic question but I can't find the answer in the help files or other resouces I have. Though it's used in the book I am using (Access 2000 Programming - Weekend Crash Course) it is not ever explained. What exactly does Me! refer to? Is it the current form? Thanks...