How do I limit a dropdown list to a specific set of records in a table based upon an earlier selection by a user in a form?

I'm not sure that Forms is the right place to post this because this also happens if I try and add or try and change an existing record. I have a field in a...

I have created a database for mail merge letters. But when I go to edit a record the edit box is grey. What do I need to do to be able to edit my records?

How do I make a file folder label with large letters?

I have a database where I'm continually applying Me.Requery to fields and or pages. Can you over do this? If I have this applied to lots and lots of pages...

How can I calculate to an unbound field numeric amount and show them as an average rounded off What do i put in the form column??? Need the average rounded...

I have created a form with 5 text boxes (critical, high, medium, low, & informational) in which I want to enter data via the form. How can I use...

the ingredients of my situation consist in three tables a) Audit Reports (parent): PK = "IRB Number" b) Evaluations: PK = "IRB Number" and "Date of...

I have a form where I That has 3 columns. I want to use all 3. I set the column width to 0;1;1;1 When I try to change the Limit To List to No I get message...

I have an option group of 4 different choices (Source Report, Destination Report, Special Report, Origin Report) The values set for these are 0,1,2,3 On my...

A2000. If I disable all of the controls on a form, in DataSheet view the form current event /may/ not fire. Typically, clicking down the list I can get a...

Hello All I am using A97. I have the following code behind an option group on a form, but it doesn't work and when I try to compile I get the message "Method...

I have as form with two combo boxes that force the user to select combinations of values that have been pre-defined in 'Setup' table. The RowSource of the...

I have a field "callback number" that defaults to the callerID phone number. HOwever, on the rare occasion that the callback number might be different than the...

I have a simple form consisting of a text box in which the user enters a name in the form 'LastName, FirstName', and a combo box which allows the user...

Rate is a control, the other field is not bound I am trying to use the messaage box if amounts do not match then msgbox, is this syntax correct? They both...

Trying different code to make this work. If Bidtxt is greater than Text331 then Amount is under message If '''' ' ''' Less ...

Hi, is it possible to somehow animate or at least the delay the appearance of certain labels and command buttons on a form. Basically what i have is a front...

I want my combo box to select records on my form from an underlying table. My combo box wizard does not give me the (third??) option of allowing this. I know I...

Hello, I have a race results program for a charity which needs changing. The race is longer this year so I need to include hours (as well as mins and seconds)...