I have a table of 100 staff, I have added a filter on the form, ie users select name (from a unbound combo box) and is able to scroll through all records for that name. If no records have been created for MrA and you select that name in the filter I get a runtime error,
What do I need to add to my VB that will cancel the error and state No Records held for that name then revert bank to showing all records
Private Sub CoName_AfterUpdate()
If IsNull(Me.CoName) Then
Me.FilterOn = False
Me.Filter = "StafflName = """ & Me.CoName & """"
Me.FilterOn = True
the SubForm should be link to the Main form
Link Child Fields
Link Master Fields
if these are full out the Database will keep everything in Sink you would have to do the
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.