So I am finally ready to get my new data base online (to track work updates) and my boss wanted another feature added, which was a way to be able to edit previous updates made by other people based upon the project being worked on. To that end I built another form fed by a query that would pull up the entries in a continuous form format, based upon the project selected from a list box. This data consists of 3 fields of text, a date field, and an identifier for the individual that made the entry.
The first problem I ran into was that if I opened up the form and did nothing with it, a blank entry would be made in my table where all of the update data is being stored. To fix that I made a macro that would make sure that the fields have data in them ([field X] Is Null then Cancel Event), set on the Event "Before Update".
But this led to another inter-related problem, which was that in the continuous form format of the data, the form always displays a blank entry at the bottom. For example, if there were two other entries made on that project, there would be blocks of data; two filled with the information and one blank. Without the Macro, If I didn't type anything in that bottom (empty) entry, it would save a blank record to my table. With the Macro, it wont let me even edit the data because there is a blank field.
Question: is there a better way to go about this? I am by no means an expert in Access but I would call myself an intermediate user. But I just cant think of a better way, which has got me stumped.
Thanks for your help!