Results 1 to 3 of 3
  1. #1
    Dirty_Head is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    17

    Question Searching record on form edits Record 1. How to stop from editing?

    I have a form with a CheckoutLog table as the recordsource. I have a combobox set up for "Find a record on my form based on the value I selected in my combo box." It works. I have extra criteria/order by in the query of the combobox itself to return the last individual with the matching equipment ID. This works, if I scan/type in "001001" it DOES pull up the last entry in the table based on date and if that equipment ID matched. I thought this was my final answer yesterday.



    I realized today, however, that when I make an entry into that combobox to search, it's altering/editing my 1st record's "Equipment ID" field. I suppose I could work around this by simply putting a blank record on my 1st entry and then it wouldn't matter if it edited the first entry every time, but, I'd like the table to be useful data, even if it's just one blank record.

    So, 1, how do I get it to stop editing my 1st record? and/or 2, how do I default my form to open with null data instead of an actual record until data is entered?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    The combo is bound. Remove the field it's bound to.
    1 field IS bound for the value,
    and 1 is unbound to do the search.

  3. #3
    Dirty_Head is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    17
    That was it! Thank you! I feel stupid now. Not sure why that got put in there! Maybe it defaulted!

    Edit: I remember now. I was working remotely yesterday when the office lost power. I probably lost this change from my last save.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 9
    Last Post: 12-01-2015, 10:53 AM
  2. Replies: 6
    Last Post: 07-31-2015, 12:03 PM
  3. Replies: 2
    Last Post: 08-20-2013, 01:06 PM
  4. Stop Macro on Last Record in Form
    By wdkoseck in forum Access
    Replies: 1
    Last Post: 12-04-2012, 02:25 PM
  5. Create a form that edits a specific record
    By winteram in forum Forms
    Replies: 10
    Last Post: 07-28-2011, 11:46 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums