Indicate Record in a Table - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Indicate Record in a Table

Darren McMartin

2 years ago

I have Form "A", based on Table "A". On Form "A" I have a button to open up a form based on Table "B". Is there a way of indicating in Form "A" whether there is a related record in Table "B" or not?

I was thinking of adding a Textbox to Form "A" and putting a DLookup function in it, but I haven't been able to get it to work.

Adam Schwanz @Reply

2 years ago

So, for instance, you have customer table and a customer form, then you have a button to open up an invoice form for that customer.

You can just code the button with a d function, I usually do count

If NZ(DCOUNT("*","InvoiceT","CustomerID=" & CustomerID),0)>0 Then 'There is an invoice

DoCmd.OpenForm "InvoiceF",,,"CustomerID=" & CustomerID

Else 'There is not an invoice

Msgbox "No Invoice" 'or you could open the form to a new record to make it

End If

	Juan C Rivera @Reply 2 years ago
I like this think I will try it in my new project... Thanks Adam.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View