Recent content by Chungalin

How I do it: I’ve developed a a generic scheme to handle these kind of filters. I have several unbound controls as filters, clearly differentiated from data controls (different backcolor). Each filter has a Tag property set to the filter expression like this: “fieldname = @@” (numeric)...

This happens when one just copies+pastes without understanding it.:rolleyes: In DoCmd.OpenForm call there’re 5 commas. Should be 6.

I’m telling you where to fish, but you’re asking me for the fish... ;) In code window, move the cursor over DoCmd.OpenForm and press F1. Read what OpenArgs is and then click on OpenArgs help page, there’s a sample code too! Private Sub com1_Click() DoCmd.OpenForm "frmSell", , , , ...

In frmSell: Private Sub Form_Load() List11.RowSource = "select * from table1 where tableno=" + "'" + Text9 + "'" End Sub Text9 (unbound textbox, labeled as "Table number") is Null and that causes the error. When you click on table button... Private Sub com1_Click() DoCmd.OpenForm "frmSell"...

I there, I’ve been using MS Access since ’97 version. Now I’m stuck with 2003 version. I feel comfortable with it and it covers all my data-management needs. I’ve even used it to program some applications that weren’t very data-oriented, like a subtitle editor! Something like “if all you have...