Search results

This works for the main form but I have a tab control on the main form which contains a subform that is linked to the main form. When the form opens in locked mode the subform is not visible? The subform does appear when navigating through the main forms records and a corresponging subform...

How would one create a command button to turn on and turn off the ability to allow the user to edit the data in the form? I have one main form which was built using the form wizard. In this form I have other subforms which are linked to the main form. I would like to be able to edit the data...

If I understand your question correctly, How does the latter differ from the former? Then... the latter (text field DataPanel) is a field which exist in all of the first three tables i.e.table1, 2 & 3. The former combo cmbDataPanel, which by the way your presumption is correct, looks up the...

In this case... I have 3 forms built from 3 tables, each table has a field which requires a unique entry which is a FK from a forth table. The combo box or combo boxes (3, 1 in each form ) in question is created from this forth table. Each combo box in each form allows the user to select...

What command should/could I use to save the current record after a combobox has lost focus or after update. Basically, I need know if the selection chosen in the combo box is already been assigned to another record in the same set of records (no duplicate assignments). Thanks.

RV - this works, and gives me some ideas. There is a problem. I have several combo boxes in my form. If I add this multiple times (for each combo box) it does not work and also becomes a bit compliated (at least for me)in writing out the sql but I giving it a try and have made some progress...

First, I really appreciate your help. You wrote: So when YourControl is in fact Null, the value resolves to "*". The desired resutl is... So when YourControl is in fact Null, the value resolves to "*" or Is Null. In other words, All records resolved. not just "*" records, but "*" or Is Null...

Thanks for the reply, RichMorrison. Yes, I am talking about criteria in queries. OK this works. The same as if the criteria were just.. Like "*" Or Is Null on the first row However, How can I get all records which are Like "*" or Is Null... when Like YourForm![YourControl] Is Null In other...

Any help would be greatly appreciated! The following IIF statement almost works as I would like it to. However, it only filters the records which have data contained in the particular field For instance, (Criteria: "*"). I need it to show all records, for instance, (Criteria: Like "*" Or Is...