Tabs, Option Buttons and Combobox

M

Muriukis

I have Two questions which are giving me a headache.
Question1
I have one form with two option buttons in an option group.The first option
button is for Admin and the other is Users. The Combo box has Names of both
users and admins.What I want is when the user selects one button only the
names of that respective option appear in the combo box. I dont know where am
going wrong.

Question 2
I have created an unbound main form which in I have created 6 tabs.Then in
each tab I dragged and dropped forms I had created Earlier.Now the problem is
that a certain form I had which was working earlier now isnt working.Am
getting an error that the name of the specified form cannot be found and the
macro cant run. But when I run the form by its own outside the tab its
working OK.Whats going on.
Help greatly appreciated

*Dont know and not afraid to ask*
 
S

scubadiver

1) What are you trying to achieve

2) The macro worked when the form ran on its own but now you have placed
that form inside another so the reference has changed so you need to change
the macro as well.
 
M

Muriukis

scubadiver said:
1) What are you trying to achieve

2) The macro worked when the form ran on its own but now you have placed
that form inside another so the reference has changed so you need to change
the macro as well.
Click to expand...
I want this form to be the switchboard and the tabs to have the forms is
this ok
Also in one tab I have a form called sales with a command button that
opens a nother form called payments.On payments form there is a textbox that
gets its data by looking up the total price of the last sale on the Sales
form the code is as follows
Private Sub Form_Load()

Dim sID As Integer
Forms("Sales").Recordset.MoveLast
sID = Forms("Sales").Recordset.Fields("ReceiptNo")
sale_amount = DLookup("Total", "qrySalesTotal", "ReceiptNo=" & sID)
ReceiptNo = sID
End Sub
sale_amount is a textbox in payment form. But in the tab am getting an error
that the referred form "Sales" cant be found.
Dont fault me but I have seen very attractive applications using the tabs
option as a swithcboard and the really look nice.
NB This form with tabs is unbound
 
Top