Recent content by Morpheus_UK

I had a backup so I've gone back to that. Shame lost some work, not much. Still dunno why they didn#t appear in the forms tab from the objects pane thingy.

I created a Main Switchboard form by mistake. Deleted it. Then I came to create my switchboards using Switchboard Manager, but none are the forms appear in my database window. Or anywhere? But I click on the Switchboard Manager and they appear there. but not in my forms object. Any Clues?

Yes, I wish I could explain what I am trying to do. Thanks for that, yeh I see how its the value that is changing and not the ControlSource. I have a form where I use 2 cascading combo boxes, that set values/parameters needed in a query to find the PK of the record that these 2 values belong...

On the AfterUpdate property of the combo box where you enter the 2nd value, the Unbound textbox would have to do what? Have its control source changed? Me.UnboundTextbox.ControlSource = "Qry1.column(0)" This DOESN'T WORK though, is it wrong syntax or wrong method? Qry1 is the query that...

How can I get a PK in another table, based on searching for it based on 2 values. By searching with 2 values you will always get only 1 record. READ BELOW FOR SITUATION My Problem on my form: The user enters 2 values, after entering the 2nd value a Unbound combo box runs a query, which...

That right there is v. kool, thanx for sharing Tim.

Ok simple way I found for anyone at the same level as me. Private Sub ComboName_AfterUpdate() Select Case ComboName.Value Case "All" Me!ListName.RowSourceType = "Table/Query" Me!ListName.RowSource = "QryAll" Case "Non Member" Me!ListName.RowSourceType = "Table/Query"...

:confused: What I want to do is select an option from a combo box, which changes the record source of a list box also on the same form, to an appropriate query. For instance: I have a combo box with 3 options to select from Record Source: "All";"Non Members";"Members" I have made 3 separate...

Its Ok, I will be leaving that option out, I'm sure if I have a better search on these forumns and the internet I will find out. Cheers again Doc_Man

Ok I was going to have a search option, that would ask for an age e.g. the User would enter 21 and a query would run finding records with containing 21 or higher from their age field. So if I want a database where you can search for people at and over a certain age I can do this without...

Ok, I have a table called MAIN which includes the 2 fields DOB and AGE. So far I can calculate Age field by running this Update Query: Field: Age Table:MAIN Update to: DateDiff("yyyy",[DOB],Date())+Int(Format(Date(),"mmdd")<Format([DOB],"mmdd")) Is there a way to have this Query run everytime...

Thats kool! Thanks for the reply. It is very helpful on how I will go about doing this for my form.

Is there a way to have one Command button on a form, say called UnLock, which is active (enabled + unlocked), and make everything else on the form Read Only. When You press this UnLock Command button, it makes everything on the form that was Read Only, now editable. There would be a second...

Thanks for the reply MStef, but I want one Subform only. You see each suform has a different set of questions. If you select Member from this combo box, I want a member subform displayed. If you select Non-Member, a Non-Member subform displays. The related subfroms have different questions thats...

Does anyone know how to do this. So you have a combo box on your main form with 4 options, depending on which option you select a related subform (1 out of the 4 pre-made forms) will appear on the main form. Any advice on this would be great