Search results

Here's the database.

I changed the "Description" header to "DescriptionID" and I also changed the relationship to one to many. But still did not do or change anything. Why must access be so difficult! :(

Okay now I have another issue... I am able to input information from the ItemID and Description into the table through the form now (had to change the Control Source). But now my issue is when I'm trying to enter information for the same plant ItemID/Description it replaces the old...

So I have two tables; one with Item ID and Description and one where we can put data in (In the table we have Date Entered, Quantity, Size, Item ID, Description, Location, Yard, Notes). I am trying to make a form where I can search either by plant codes or by plant names and input both into the...

EDIT: I figured it out but now how can I make it a dynamic search?

Hello Access World! I'm new to Access and I stumbled upon this place through Google. I started building a database for work (I work at a nursery) and I used John's Dynamic Search code for an Inventory Input Database but I was wondering is it possible to use this code to input data into a table...