Recent content by Joebax

Look up DoCmd.OpenForm. You can set the form type and parameters in that function and then refer to them in the form load of the called form

I had trouble with this. The combo box would not move the record pointer of the records in the main form. I used the wizard that uses a combo box to 'locate a record based on the combo box' that built some code behind the after_update property. The code generated by the wizard was this...

I am not sure what versions of access support DLookup but this is likely what you need. txtBoxName.Value = DLookup("CustomerName", "tblCustomers","Customer_ID =" & Variable Look up the syntax because I may be a bit off.

A user can allways Ctl-Alt-Delete out. You can remove the control box and the "X" or cancel the unload but if the user really wants out then you cannot really stop them. Maybe its better to set the unload event to use Me.Undo and not save the record. You can then alert the calling...

Hmm thats a bit tricky. More so than I thought. I have never needed to do something quite like this. Sounds like you have a many to many relationship rather than one to many. One Customer can have many bookings and one booking can have many customers. But in this case you only want two, a...

Have you set the Child and Master linking properties? This is can happen automatically or sometimes you have to set them. When you select the child table look under the data tab for these properties.

Try searching either here or on google for "Word Automation" Hope that helps. I dont use it much myself.

I guess I would need to see a basic table description and the rowsource definitions of the two combo boxes to fully understand what you are trying to do. As to your original questions. If you could somehow get the SQL text that is the source of your recordset then you could assign that as the...

I only know access 2003 and not much at that, but this is what I would do. Make sure you have a relationship between your customer and booking table, based on Customer_ID. (You can right click on the tables area and choose relationships.) Then open your customer form and make it larger. Then...

If you are building filter text why cant you build a where clause instead?

If you are building filter text why cant you build a where clause instead?

You should be working with what was your sub form. I am guessing the fields in this table would be "Functional Group/Task Status/Task Name/Task Description/WO #/Funded Hours/Notes". With a Customer_ID that links to your customer table. When you run the form with no changes at all, you should...

Me is a special shortcut so that you do not have to type in the name of the form. I would put the code in the after_update event of the combo box.

It looks like I am able to update the forms record source to only the stock_id in my stock combo box. This seems to work for now but I would still like to know if there is a way to disable all record navigation. :)

Open your main form and select the subform in the properties window drop down. Under the data tab you should see the linking fields. I would try this: Forget the main form and work only with your sub form (which would then be a main form). Your record source will be set to all rows in the...