Recent content by krop

Doh! I thought it was a footer property. Thanks for the info. Krop

How do I hide the the default from controls in that I can just have my own add record, next record & previous record buttons. TIA, Krop

Have done it now by using: INSERT INTO model ( model, supplier_id, equipment_type_id ) VALUES (([Please enter new Model:]), (forms!myHardwareForm!cbo_Equipment_ID), (forms!myHardwareForm!cbo_Supplier_ID); Thanks for stopping by though...

INSERT INTO model ( model, supplier_id, equipment_type_id ) SELECT ([Please enter new Model:]), hardware.supplier_id, hardware.equipment_type_id FROM hardware; Hi, hope you can help. I've looked on the net but can't find understand anything relevant. In my main form the user selects a...

Thanks very much, IMO! Why on earth was I using the Form Wizard instead of basing my form on queries in the first place!? It works now and I'll be able to add extra fields on easily at a later date. Thanks again!

I can't I'm afraid as the tables are linked tables from an SQL database. There must be a way to add them or how else do people create forms without using the wizard? Rgds,

OK, I feel really silly for having to ask this but I can't work it out... I need to add a simple bound text box to a form in design view. However, it's not listed in the field list so I can't just drag & drop it and if just draw on a text box then click properties, control source, [...], and...

I've managed to solve it! It just seems that SQL doesn't like 2 "in" statements followed by subqueries. Here's the code that works: select dbo_model.id, dbo_model.supplier_id, dbo_model.equipment_type_id, dbo_model.model from dbo_model, dbo_hardware where...

I have 3 combo boxes and I would like them to interact as follows: Equipment Type - (e.g. PC, laptop) Regular Drop Down Supplier - (e.g. Dell, Toshiba) Shows only suppliers of selected Equipment Type Model - (e.g. GX270, 2410-703) Shows only models of selected Supplier AND Equipment Type I...