Search results

I was able to recreate this situation but have not figured out how to get the new switchboard to show up in the database window yet. You could always opt for using a custom made form for your navigational needs. I think it's better and more versatile anyway.

If the code works for you, place it in the oncurrent event of your form in addition to the after update.

Would it be possible to delete your profile and recreate it? Stranger things have happened! :eek:

Try making a new form and see if that works. Right click your table and choose save as. Then tell it to save as a form.

http://www.access-programmers.co.uk/forums/showthread.php?t=36043

This doesn't have the PK - FK setup but you may find this interesting...... see attachment

I just tried this and it works if txtbox is either enabled or not enabled If Me.txtbox = "freshman" Then Me.txtbox2.Visible = True Else: Me.txtbox2.Visible = False End If txtbox2 has to be set to visible = no

Did you set the visible property of your text box to no?

I just tried it and it works without the me.refresh.... Thanks for pointing that out!

Sorry, my mistake It needs "" so try this: If Me.Type1 = "Check" Then Me.Check1.Visible = True Else: Me.Check1.Visible = False End If Me.Refresh If you were using a numerical value "" around the value of Me.Type1 would not be needed EG If Me.Type1 = 12 Then

No, that's where it should be Make sure the names are correct and it should work fine

Set the visible value of Check1 = no If Me.YourComboName = check Then Me.Check1.Visible = True Else: Me.Check1.Visible = False End If Me.Refresh

Open the .ldb with notepad. The info is inside. There are other applications that will do this for you but this is quick and easy.

Guess I should have elaborated more. The RecordsetClone is used for a listbox. This is when it is was happening.... when I change the combo's value, the listbox is filtered on the new entry in the combo. I have it sorted I believe. I relinked the tables and it seems to be working ok now. Strange

In the onchange event of a combo I have this code: Me.Form.Requery If Me.RecordsetClone.RecordCount = 0 Then MsgBox "Sorry, no records meet your chosen criteria", , "Notice!" End If This is used in several different DB's and has been working well. All of a sudden one of them has started...

Maybe you could make a copy of the DB and delete all of the data from the tables. Then you could post it?

There is a lot of wonderful info on this forum and the search feature does work well. I found this for you in the sample database section: http://www.access-programmers.co.uk/forums/showthread.php?t=63766&highlight=search

You can use a check box if that is what you want, or any one of a zillion different ways. Set the visible property of your label or text box to no first. Substitute your names. Private Sub CheckBox_AfterUpdate() If Me.CheckBox = yes Then Me.TextBox.Visible = True Else: Me.TextBox.Visible =...

Try the search function of this forum. It works well and this subject has been covered at length: http://www.access-programmers.co.uk/forums/search.php?searchid=573156

If you have multiple levels of users and have a tough time getting the switchboard to look correct when you are turning buttons on and off, here is a thought. Create a hidden form that opens when the DB opens. Use whatever suggestions you prefer above to determine the user's level. Have...