Hi, thanks for these videos-- they have been life altering!
I have a question for you regarding forms. Here is our scenario: 1. We are importing an excel table from an external source. 2. This table contains some, but not all, of hte information we require. I have added the extra fields into the table. 3. I have created a form that can be used to call up that record. Some fields will autopopulate from the imported table, and some are blank and ready for the additional information to be entered.
It all works quite brilliantly except... I want to allow for the scenario where a record is not already in the imported table. Ideally, if a record is not in the original table, I would like the form to blanked, allowing for ALL fields to be manually entered.
What I found was that if I entered the identifier for the record (indexed, no duplicates allowed), if it was not on the list, it CHANGED the current record to that new number. This cannot be allowed. If I made the field so it could not be edited, I couldn't enter any new numbers at all.
What I would like is- if I entered the unique identifier and it is in the table, that it calls up that record (which works), but if that unique identifier is NOT in the table, I would like a blank form to come up.
Is this possible? Thanks, Natalie
Reply from Richard Rost:
Life altering? Wow. Thanks. :)
Sounds like you should use a DLOOKUP to determine whether or not the record exists in the other table. If so, import it. If not, load a blank page. The bad news is that this is going to involve a little programming. The good news is that you can probably do it with just a few lines of code. Check out the link for more help.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 3.