Problem: An undefined number of persons can bid on an item (usually 4 or less bidders). Can I write a macro that will check to see if the Bidder1 Field is empty or filled? If it is empty, it enters the new data. If Bidder1 contains data, the macro automatically moves to Bidder2 and checks for data...and so on through Bidder4?
Conditional Macro that Opens New Fields (1 Viewer)
- Thread starter oceano79
- Start date
- Local time
- Today, 08:15
- Joined
- Aug 30, 2003
- Messages
- 36,124
Can it be done? Yes. Should it be done? No. You should not have bidders as fields, they should be records in a related table:
http://www.r937.com/Relational.html
http://www.r937.com/Relational.html
Pbaldy - thanks. Makes absolute sense to make these records instead of fields. Your reply helped me think through the issue. My real problem is that I need the Bidder records to be input via a web app that (1) Posts open bids and (2) Allows Bidders to self-identify. Bidder records would then be collected and added to the appropriate table. I am very new to Access and not familiar enough with Web Apps to complete this task. Maybe in a few weeks I will know enough to post a better question.
- Local time
- Today, 08:15
- Joined
- Aug 30, 2003
- Messages
- 36,124
I haven't used the web app, so may not be able to help much with that. Generally speaking, I'd have a transactions table, where every bid was a record. You could have one or a million, and it would be easy to identify the highest/lowest.