Search results for query: *

Thanks. This is off-topic, but what is a good reference for the syntax and keywords in VB as it relates to Access?

Table1 is related to Table2 on a 1:M basis (many records in Table2 for each record in Table1). Table1 is the data source for Form1 and Table2 is the data source for Form2. The OnClick event for Button1 on Form1 is linked to a macro that performs the action OpenForm on Form2 where...

I wrote a macro for a button in one form that opens another form and goes to a record that shares info in a related field with the active record in the first form. It works perfectly the first time I use it, but then the process breaks down. If I come back to the first form, change records and...

I have two forms based on tables that have a 1:M relationship. I want to create a button on the parent form that will: (1) open the child form (2) go to the record in the child form containing matching data in the related field as the record that was selected in the...

You nailed it. It wasn't bound column of the combo box on the form, but the bound column of the field in the source table was set to 0. I guess that's why the value in the table was showing up as more of a list index value. Thanks.

Thanks guys, that really helped. I did have to put the code in both the On Current event of the form and the After Update event of IsTrue in order for it to work under any combination of events between the opening of the form and the checking/unchecking of the box.

When I enter data into a form in a particular field, the data appears differently in the form than it does when I open the table that the form is linked to. Specifically, I have three combo boxes on the form that are linked to each other. The list of options for the second one is limited by...

Thanks for your help.

Thanks a lot. It worked perfectly.

Is it possible to hide/reveal controls on a form depending on the value of a yes/no field on the form? For example, given a form named "MainForm", two controls named "OnlyIfIsTrue1" and "OnlyIfIsTrue2", respectively, and a check box named "IsTrue" bound...

This seems to be a popular question; however, I was unable to find an answer that worked from the other threads in the forum. Given a main form named "MainForm" and a subform displayed in datasheet format on MainForm named "SubForm", what code would one write for a button on...

I followed the above steps, but the date will not appear in the date field on the main form. Do I have to refresh the field somehow?

On a form I have two bound combo boxes. I want to limit values displayed in the second combo box based on the user selection from the first combo box. The field (field A)that the first combo box is bound to is the primary key of table A. Table A is related to table B via this field in a...