Pop Up (I think)

[Derrick]

I'm new bear with me please I am using access 2010:

I have two tables:

One table prices by country
Two table enter shipping information

I want the country box on dirty to show a pop up message box saying the country is available from Table One or the country is not available?

When I put an IIf x = x statement the objects are not related so it doesnt work?

If I make a query then every record shows up on a datasheet I only want the one I am working on to display (preferably in a pop up box?

Possible??????

 

[NickHa]

You don't give much information to help us to solve your problem here.

I want the country box on dirty to show a pop up message box saying the country is available from Table One or the country is not available?

What do you mean by "country box"? Is this a combo box on a form? If so what is the form bound to - the shipping nformation table?
I would not advocate a pop-up box in the context you describe. What is the user to do with the box? If it always shows with 'present' or 'not present' for the country, it seems clunky from the user experience point of view. Would it not be better to show an information message in a label on the form, with the required action indicated?

When I put an IIf x = x statement the objects are not related so it doesnt work?

What is the context of the IIf statement you tried? Is it in VBA, a query ...? Are the objects you refer to the two tables mentioned? Is there no common field between the two tables? It would help if you provided greater detail about the table fields and indicated the link field, if present.

If I make a query then every record shows up on a datasheet I only want the one I am working on to display (preferably in a pop up box?

Is there a specific filter value you can apply to the query (WHERE x=y) to limit the rcords to the one you want?

 

[Derrick]

I am sorry like I said I am a novice.

I just want to ensure the person inputing a shipment does not enter a country that is not covered by the service.

i.e. person enters Spain Priority service, I want the pop up to come up and say Spain does not have a priority service.

I cant restrain the country by only allowing the list of countries in the combo because Spain may have a standard service but not a priority service.

The country and service is held on a seperate table from the shipment details table.

Guess thats as clear as I can make it?

 

[speakers_86]

Then it sounds like you need to change the combo boxes record source in the onClick event.

 

[John Big Booty]

Perhaps what you need to do is to use a set of Cascading Combo boxes to filter the services that are available to/from each country.

So you user would first select the country which would then filter the services that are available to/from that country. In that way your user is unable to make an invalid selection.