• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

cannot modify a forms's Recordset and Bookmark properties remotely from another form. (1 Viewer)

llyal

Registered User.
Local time
Today, 22:22
Joined
Feb 1, 2000
Messages
72
Problem: I cannot modify a forms's Recordset and Bookmark properties remotely from another form.

Overview: I have a main form used to enter and display data. User wants search to be done many different ways, preventing me from putting the search on the main form because there is not enough room. If i could do that, i would not have this problem! Instead, I added a search button to open another form that can display all the search options, and from here the search will be made and then the main form recordset will be updated. One type of search uses a combo box lookup. I am familiar with doing combo box lookups when the combo box is on the same form, but what does one do when the lookup is being done from a remote form? I cannot get the main form to update its recordset. With the following code i get a "Application-defined or object-defined error".

Code:
Private Sub cboByTitleLookup_AfterUpdate()
Forms!frmLibraryBooks.Me.Recordset.FindFirst "[BookID] = " & Me![cboByTitleLookup]
Forms!frmLibraryBooks.Me.Bookmark = Forms!frmLibraryBooks!RecordsetClone.Bookmark
DoCmd.Close acForm, "frmLibraryBooksSubLookup", acSaveNo
End Sub

Thanks for the Help!

Llyal
 

Users who are viewing this thread

Top Bottom