Search results

Try here it has the syntax for referencing different controls and fields on parent and subforms

You could add a Check Box field to your tool record and call in something like "On Hire". As part of your booking in and out process you would need some code to check the box when the tool is hired out and then clear the box when it is returned. This would also mean that at the very start of the...

Me.RecordSet.RecordCount = 0 Tells you there are no records. You could test for this in the OnLoad event of the form and put up a MsgBox

What to do with a mountain pass and a few spare inline skate wheels :eek: More info here

To answer my own question :o Yes. I just put a logical check on the "On Lost Focus" event of the first field of the (continuous) SubForm to check if it contained any data, if not it set the focus back on to the main form. Should have thought a bit before I posted. Sorry :o

Is there a way of tabbing out of a SubForm once you have finished entering data into it?

You will need to force the form to refresh, after each check box is clicked.

You could do an IF OR logical test of the two dates against Date() and then show the appropriate result.

I'm sure it can be done, but I must admit, I've never put any thought into actually doing it :o

You should find that the client that has been added will now be available for selection from the Combo Box.

I use Firefox as my default browser, yet when I click on a hyper link in a form the link will open in IE rather than Firefox :mad: Is it possible to change this behavior, so that links will open in (a new tab in) the default browser?

Perhaps you need to select No "Record Selectors" in the Form properties in design view.

Easy just put the following code behind your form's on close event or on a button's on click event;

(Retail Value)*(100-Discount)/100

In addition if you store first and last name separately it gives you a whole lot more flexibility as to how the names can be display and used on forms or reports, that you would loose if you stored them in one field. For example if you had the name Kym Byrnes it could also be displayed as...

You will need a third unbound TextBox in the control source for that text box put the following; =[frist name] & " " & [last name] You might want to think about renaming your fields to not include a spaces, to say FirstName or First_Name. The way I have used bullet points or symbols is to...

Bump ^^^^^

Use the OnCurrent event of your form to test for ID # 1, if current record is ID # 1, then lock that record, else record is not locked. HTH

The following might be what you are looking for; Dim stDocName As String Dim stLinkCriteria As String stDocName = "FRM_FormB" stLinkCriteria = "[LinkingID]=" & Me![LinkingID] DoCmd.OpenForm stDocName, , , stLinkCriteria

In the on click event of your button put the following; Dim stDocName As String stDocName = "FRM_Name" DoCmd.OpenForm stDocName, , , , , , "New" 'The last part of this line is the OpenArgs and could be any descriptor you choose In the OnLoad event for your form "FRM_Name"...