Recent content by RACHNA

How can I display the values of one combo box based on another? For instance, I have a Hospital Combo box and I want only the units for that hospital to appear in the Units Combo box. I have two tables (Hospital and Hospital Unit) which are linked by hospital Unit. Thanks!!

Is it possible to have a combo box that a user can enter new values in right from the form. These then should appear in the underlying table? Thanks much!!! [This message has been edited by RACHNA (edited 02-07-2000).]

I tried this code and I still get the same results. So I tried the following: Age = DateDiff("yyyy", [DOB], Now()) + _ Int(Format(Now(), "mmdd") < Format([DOB], "mmdd")) Thanks! [This message has been edited by RACHNA (edited 02-04-2000).]

I'm using the following code to compute Age based on Date of Birth. (i'm using 4 digit year) Private Sub DOB_AfterUpdate() Age.Value = DatePart("yyyy",[Now]) - DatePart("yyyy",[DOB]) End Sub I'm getting bad results and realize I need to use month and day in the calculation. Any ideas how...

I have a switchboard which has actions for the database it resides in i.e open form, open report etc. How can I create a button on it to open another database? Thanks much!!

I have some a combo box named status with the following values Status: Accepted Rejected Incomplete Deflected Wthdrawn In a report how can I show how can I show the number of times each value is chosen? i.e Show how many times "Accepted" is chosen? Thanks!!

I have a combo box field on my form for Grade Level (1-5). I'm looking for a way to advance all students to the next grade. 4th Graders->5th Graders 3rd Graders->4th Graders 2nd Graders->3rd Graders 1st Graders-> 2nd Graders Any suggestions would be helpful

For some reason, the field was not recognized on the subform in my calculation. Spelling was correct. I've added the date fields from the subform to the main form and it works fine. I appreciate the help!

I've tried both of the suggestions above and i'm still not successful. -still got #Name? (Eason) -nothing happened (Travis) Any other ideas? Thanks much!

I'm trying to calculate a date field on a subform based on a date field on the parent form using the following expression in the control source of the subform's date field i'm trying to calculate: ( I want the field to be 10 days from the Admission Date)...

I have a tab control on a form, in the detail section, with several pages. I also have a header and footer section. There is a command button to Print the current record, however, when I click this it only prints the header and detail section. I have tried cliking yes to the keep together...

Can a Combo Box's Record Source include multiple tables and queries?