Search results for query: *

Hi, I have a combobox which is used to select a value and open a customer record form based upon the order item selected. If I select Orderitem ID 3 it corresponds to Customer ID 5 - so customer 5's details are shown on the form that opens. However, within the customer form I have two...

Thanks AceMan :)

Hi, I have a form with two text boxes to enter a from and to date range. I would like the default value of the from text box to be the lowest date within the database and the default value of the to text box the highest date in the database. I can get the lowest and highest dates from a query...

Thank you Remou. It works perfectly. :)

Hi, I have 8 buttons on a form. Each one opens a report using VBA. e.g Private Sub Command43_Click() On Error GoTo Err_Command43_Click Dim stDocName As String stDocName = "ordergeneralreport" DoCmd.OpenReport stDocName, acPreview Exit_Command43_Click: Exit Sub...

Thanks to all, Ray Vidar's solution looks simplest. thread702-958217 But I get stuck when he says: In the on current event of the form, assign a unique value of the form to the text control (primary key, let's say txtID). Can anyone please clarify what I need to do? Thanks.

Hi, I have a datasheet and when a row is selected (or any field within that row) would like the row's background color to change. Thus highlighting the selected row. What is the simplest way of achieving this, please? Many thanks. Simon.