Alright wizards,
Got another one that's been stumping me. I've attached a sample database to help with the explaining. I'd like the "location" and "pick aisle" fields in the form to auto fill based on the "material" field which my users will add in manually. I've got the dlookup function to work before but it won't save that data from those fields into the Table the form is based off of (running log record)
any assistance would be spectacular!
Got another one that's been stumping me. I've attached a sample database to help with the explaining. I'd like the "location" and "pick aisle" fields in the form to auto fill based on the "material" field which my users will add in manually. I've got the dlookup function to work before but it won't save that data from those fields into the Table the form is based off of (running log record)
any assistance would be spectacular!