Search results for query: *

lupins46: Thanks for the response. Using a JOIN I can select the relevant fields instead of '*'. Konacq

I have an option button on a continuous subform bound to a field called 'Default'. The subform shows a subset of records based on a SELECT statement using criteria derrived from fields on the master form. The idea is that one (and only one) record within the set of records returned from the...

mama16: It depends upon the level of detail you are interested in, but two detailed and well presented books I highly recommend are: Microsft Access Inside Out, published by Microsoft, ISBN 0735615136 Microsoft Access Bible, published by Wiley, ISBN 0764539868 Konacq

rwolff: If you just need two forms side by side, why not create one form with two subforms embedded side by side? Use the controls on the main form to index which records are displayed on the subforms, in effect creating a continuous side-by-side form. Konacq

Viv1: You can recalculate the age each time the form opens, as in: Private Sub Form_Open(Cancel As Integer) Me!Age = DateDiff("yyyy", [DOB], Now()) + Int(Format(Now(), "mmdd") < Format([DOB], "mmdd")) If Me!Age > 40 Then Call My_Function End If End Sub The problem is, you...

Zor, AceMan1: That's got it. You were both right. I now realize that, when I was viewing the properties, I was viewing the properties of the second form as a form - not as a subform. With your assistance, I have discovered how to view the subform properties. Thank you for pointing me in...

Zor: Thanks for the very prompt and helpful reply. Yes, I do have the relationships defined as one-to-many in the relationship building tool (one is the master, many is the subform). When I use the subforms icon on the tools menu as you suggested, I was able to create a subform, and it...

I am new to sub forms. I created one successfully, and I manually entered the Link Child" and "Link Master" fields, but now the "Link Child" and "Link Master" fields on the sub form's properties are not available. When I created a new subform by dragging a form onto another form, I can't see...