Search results

Welcome to the forum. Given the your Master cache is on your Main Form and the Dependant Combo is on the Sub form, you will need to check this link to get the correct syntax for the reference between the combo boxes. It will look something along the lines of; Me.Parent!ControlName You will...

I believe the limit is 255, however I suspect that if you are running into this limit, you may have a problem with your table structure. Read up on normalisation and perhaps work through a tutorial.

Welcome to the forum. You would need to build a query based on your form and use the "Or" operator to search your field. This link should help you with that task.

You could use the Lost Focus events of the fields involved to for a Requery. Me.Requery Should do the trick. To over come the #Type error you could use the Nz() function to provide a working value when one of your controls hold a Null value

Joe in your transition from Excel to Access, one the first (and possibly hardest) concepts you will need to get your head around, is that of Data Normalisation, you may find working through a tutorial helpful in this process. You are going to have to push everything you know about Excel to the...

Welcome to the forum. Congratulations you have just discovered one of the little quirks of continuous forms. Using fields that derive their value from another control on a continuous form are always going to be problematic. As ALL instances of the dependant control will reflect the value held...

You would put the code in the Combo's Got Focus event. (I'm currently working from memory, as I'm on the road and this machine does not have Access. The description should be pretty accurate but some of the word may be slightly different). With your form in design view, click on the combo. Now...

Welcome to the forum. Perhaps the thread and sample here are doing the sort of thing you are looking for.

Have a look at the SelStart property. Your code might look something like; Me.YourComboName.SelStart = 0

Perhaps the discussion here will give you some pointers.

I think the discussion in this thread should provide an answer to your question.

You may be able to find a model here that you can adapt to your needs.

Perhaps the discussion and samples here will give you some pointers.

Have a look at the DoCmd.OpenForm method as well as the DoCmd.Close method

If you have bound the field on the form to the correct field in the table. Make sure that the fore and back colours are not set to the same value. If you are able to post a copy of the DB, I'm pretty sure that someone here will be able to sort the problem out in short order.

The trouble with using VBA in this instance, is that on a continuous form all records will be effected by the value held in the record that currently hold focus. Have a look at Conditional Formatting.

Welcome to the forum. I'm currently on the road and do not have access to Access :D so can't take a look at your samples. However you may find this article helpful in your attempts to understanding Cascading Combo Boxes. The sample here has a slightly different take on the topic and may be of...

I'm somewhat confused by your post :confused: However the thing to bear in mind, when you set a default value for a field is that this new default value will only appear in new records created after you made the change to the form/table structure.

Probably a silly question: but is the field on the form bound to the correct underlying field in the table?

When you are dealing with a subform, the syntax for referring to controls and fields on it changes slightly from that which you would use for controls and fields on a form. Bookmark this link for future reference, as it shows the correct syntax for referring to subforms, their controls and...