Recent content by hyousef

I have a popup form which contains 2 command buttons that open other forms onclick. when a user click on a command button in a popup form another form should open. How can i minimize the popup form when the other form opened. Thanks in advance

There is no any subform....i have form1 and form2....I need to pass area from "a command button area" in form1 to a "combo area" in form2. i know how to do it If there is already data in form2 that related to a selected area. but If no data is present in form2 that related to the selected area...

I have 2 forms, Form1 and Form2. Form1 has 5 command buttons, all of them take a user to Form2 but they are different areas for example: Button1(Area1), Button2(Area2)...etc. when a user press button1(Area1) then Form2 opens and has data related only to area1. If a user press button2(Area2)then...

Thanks a lot Fizzio, its working.

I just emailed you my DB. Thanks a lot.

Nop Fizzio, it didn't work...Can i email you my DB so you can have a look?

ok, i have 2 syncronise combo boxes. in after update for the first one i have the following: Private Sub cboBudgetRef_AfterUpdate() cboActivityName = Null cboActivityName.Requery Me.Requery End Sub In the criteria box in my query i have: [Forms]![EngineerAssignment]![cboBudgetRef] in the...

Fizzio, This is work with records but in my case: when a user choose from the combobx and there is no record match the criteria then the subform doesn't open and it will not be shown...in this case i want the command button to appear so a user can add a new record. but if there is a record...

I have a subform in a form. In my form i have a combobox and a command button. When a user choose form the combobox then the data appears in the subform. Sometimes, when a user choose an item from the combobox, it doesn't return data or records. what i want is to show the command button only...

i added the close sentence in the new form and its working. Thanks guys.

May be i didn't explain well in the previous message. ok, I have form1, form2, and form3. Form1 is the main form which has the combo Box that users need to select from to go or to open other forms. when a user choose to open form2 from the combo box, it should open from2 and close...

My main form has a combobox. Users can choose from a combobox to open a form. I got this to work but i need to close the main form when another form is open. How can i close the main form after a user choose an item from the combo box? I know how to do it with a command button by Macro but how...

Thanks Fizzio, it works.

I want to fill in one field automatically from previous record. i have done the following but i didn't get what i want, it filled in all fields but i want only one. Function AutoFillNewRecord(F As Form) Dim RS As Recordset, C As Control Dim FillFields As String...

Shep, i just sent you the DB. I am using MS Access 97. Also, i am using queries not macros.