Help! Extracting Data from table to Form.

[iProRyan]

Hi Guys,

Could do with some help, am doing a Database for a school project, yes I am allowed help, it's not cheating, in fact I'm meant to do research, so this is it.

I am making a database for a DVD Rental Store, on my Rental form I have it so you enter the ID of the DVD, how do I make it so once that ID is entered the other fields such as the DVD Title, Cost Per Night, and Overdue Daily Cost are automatically filled in form the data which is stored in a table called DVDs.

Hope this makes sense.

Thanks,
Ryan.

[June7]

You are doing data entry in a form? Include the DVDs table in the form RecordSource by building a query that joins on the ID fields. That's one reason for queries - to view related records in one dataset. The query will allow display of the related info from DVDs table but you don't want to allow edits of those fields from this form so set the textboxes as Locked Yes and TabStop No.

Access Help has guidelines on building queries and forms.

[iProRyan]

Yes, I'm using a Form to enter the data.

How would I build that Query?

[June7]

Building queries is basic Access functionality and Help has guidelines or Google for tutorials. You can use the Query Designer to build and save a query object then refer to that query as the form's RecordSource. Or build the query right in the RecordSource. In the RecordSource property click the ellipses (...) to open the query designer. The result will be an SQL statement in the RecordSource.