Simple Question - some help required

[Playbus]

Hello everyone

I'm not too hot with Access yet, but I'm starting to get there.

Here's my question:

I am building a database to deal with queries from customers. It's very simple. I have a table and a form for queries, and another form and table for the responses to the queries. This all works, no probs here. They even update each other. Woo!

I have a button on the query form which brings up the form where responses can be entered to the query. Each query can have as many responses as necessary, which is the way I want it -- but I want the user to be able to click on a button (on the response form) which marks the whole query as complete and from that point on not allow any more responses.

So what I think I need is a macro or code which, when the user presses the "Add response" button, it checks if the completed field is set to Yes. If it is, I want a message box to pop up saying something like "This query is closed" and if not I want it to allow a response to be added as normal.

I hope that made sense.

Can anyone help me?

 

[Mile-O]

I hope that made sense.

Sorry, it didn't.

I am building a database to deal with queries from customers. It's very simple. I have a table and a form for queries, and another form and table for the responses to the queries. This all works, no probs here. They even update each other. Woo!

You shouldn't bind tables to forms - you should make queries of these tables and sort them accordingly (and set any criteria to remove unnecessary records, should there be any).

It's this bit that I don't understand:

I have a button on the query form which brings up the form where responses can be entered to the query. Each query can have as many responses as necessary, which is the way I want it -- but I want the user to be able to click on a button (on the response form) which marks the whole query as complete and from that point on not allow any more responses.

A query with as many responses as necessary?
Marking the query as complete?
Restricting further responses?

So what I think I need is a macro or code which

Code. Always code. Never macros.

Can you upload your database structure with some dummy data so that I can see what you have as it may just be a question of terminology.

 

[Playbus]

Nevermind, I have worked out what I need to now.

Thanks all the same.